-[ 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                                                                                                                                   +
                 |                         INNER JOIN content c ON e.targe
backend_type     | client backend