-[ RECORD 59 ]---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 99085638
datname | softwareheritage
pid | 479899
leader_pid |
usesysid | 16384
usename | guest
application_name |
client_addr | 192.168.101.162
client_hostname |
client_port | 45722
backend_start | 2021-05-23 22:05:45.203118+00
xact_start | 2021-05-23 22:05:45.289264+00
query_start | 2021-05-26 13:13:16.822506+00
state_change | 2021-05-26 13:13:16.846265+00
wait_event_type | Client
wait_event | ClientRead
state | idle in transaction
backend_xid |
backend_xmin |
query | WITH +
| dir AS (SELECT id AS dir_id, dir_entries, file_entries, rev_entries +
| FROM directory WHERE id='\x40996ac0fd289bd77598b603393961b73fcd2b1b'::bytea), +
| ls_d AS (SELECT dir_id, UNNEST(dir_entries) AS entry_id FROM dir), +
| ls_f AS (SELECT dir_id, UNNEST(file_entries) AS entry_id FROM dir), +
| ls_r AS (SELECT dir_id, UNNEST(rev_entries) AS entry_id FROM dir) +
| (SELECT 'dir'::directory_entry_type AS type, e.target, e.name, +
| NULL::sha1_git +
| FROM ls_d +
| LEFT JOIN directory_entry_dir e ON ls_d.entry_id=e.id) +
| UNION +
| (WITH known_contents AS +
| (SELECT 'file'::directory_entry_type AS type, e.target, e.name, +
| c.sha1_git +
| FROM ls_f +
| LEFT JOIN directory_entry_file e ON ls_f.entry_id=e.id +