postgres=# SELECT version();
                                                              version
-----------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 10.4 (Ubuntu 10.4-2.pgdg14.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.4) 4.8.4, 64-bit


postgres=# SELECT * FROM pg_stat_activity WHERE pid IN (22591,22607)\gx
-[ RECORD 1 ]----+-----------------------------------------------------------------------------------------------
datid            | 16400
datname          | da
pid              | 22607
usesysid         | 16384
usename          | da
application_name |
client_addr      | 192.168.37.43
client_hostname  |
client_port      | 57089
backend_start    | 2018-08-07 15:00:44.198289+03
xact_start       | 2018-08-07 15:24:43.165418+03
query_start      | 2018-08-07 15:24:43.165418+03
state_change     | 2018-08-07 15:24:43.165421+03
wait_event_type  | Lock
wait_event       | relation
state            | active
backend_xid      |
backend_xmin     | 1065072121
query            |                                                                                               +
                 |                 SELECT                                                                        +
                 |                   s.storage,                                                                  +
                 |                   fm.path AS filepath,                                                        +
                 |                   s.url AS serverurl,                                                         +
                 |                   cf.title AS type                                                            +
                 |                 FROM kaltura_file_meta                                                        +
                 |                 JOIN files fi ON file_id = fi.id                                              +
                 |                 JOIN content_format ci on ci.id = fi.format AND ci.title = 'VODHLS-FPS-ABRSHQ'+
                 |                 JOIN files fm on fm.id = any(mp4_file_ids)                                    +
                 |                 JOIN content_format cf on cf.id = fm.format                                   +
                 |                 JOIN servers s on s.id = fm.server_id                                         +
                 |                 WHERE cf.title LIKE 'MP4%'                                                    +
                 |                   AND substring(fi.path from 1 for 34) = 'e/2/24285854bae493728262bc89786f9a' +
                 |                                                                                               +
                 |                 ORDER BY cf.title                                                             +
                 |                 ;                                                                             +
                 |
backend_type     | client backend
-[ RECORD 2 ]----+-----------------------------------------------------------------------------------------------
datid            |
datname          |
pid              | 22591
usesysid         |
usename          |
application_name |
client_addr      |
client_hostname  |
client_port      |
backend_start    | 2018-08-07 15:00:43.285428+03
xact_start       |
query_start      |
state_change     |
wait_event_type  | Lock
wait_event       | relation
state            |
backend_xid      |
backend_xmin     |
query            |
backend_type     | startup