Visualizando as consultas atuais do PostgreSQL

psql=# SELECT datname, pid, query_start, query FROM pg_stat_activity;


datname | pid | query_start | inquerir



encenação tvgrid | 29744 | 17/06/2013 05: 13: 37.141552 + 00 | SELECT * FROM " tentativas de trabalho "


tv_staging |
16879 | 17/06/2013 05: 11: 21.847827 + 00 | SELECT contagem (*) FROM "inscritos"



</pre>