Plugins » Katello

]$ psql -c "SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity WHERE state = 'idle in transaction' AND query NOT LIKE '%pg_stat_activity%';"

pid | age | usename | query

---------+-----------------+-----------+-------------------------------------------------------------------------------------

2961991 | 00:09:44.941712 | candlepin | SELECT * FROM public.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC

(1 row)