Queries stat - prayagupa/rdb GitHub Wiki

Redshift

select * from stv_recents where status='Running';

select * from stl_query where pid in (select pid from stv_recents where status='Running')

select * from stv_locks;

Pg

-- https://stackoverflow.com/a/55175077/432903

postgres=# SELECT pid, query, usename, client_hostname, state, backend_xid FROM pg_stat_activity;
 pid |                                         query                                          |  usename   | client_hostname | state  | backend_xid 
-----+----------------------------------------------------------------------------------------+------------+-----------------+--------+-------------
  24 |                                                                                        |            |                 |        |            
  25 |                                                                                        | postgres   |                 |        |            
 121 | SELECT pid, query, usename, client_hostname, state, backend_xid FROM pg_stat_activity; | postgres   |                 | active |            
 184 | select * from sku_inventory;                                                           | skudb_user |                 | idle   |            
  21 |                                                                                        |            |                 |        |            
  20 |                                                                                        |            |                 |        |            
  23 |                                                                                        |            |                 |        |            
(7 rows)