DB‎ > ‎Postgres‎ > ‎

check current PostgreSQL activites

Thank you for visiting this page, this page has been update in another link How to check current postgresql activities
Have a quick look about PostgreSQL current activites

select usename, current_query from pg_stat_activity where datname='testdb' and current_query<>'<IDLE>';
 usename  |                                              current_query                                             
----------+----------------------------------------------------------------------------------
 postgres | autovacuum: ANALYZE public.srmspace



Comments