If I am not wrong, you must be asking about this:
select * from pg_stat_activity;
If you see in the query column.
Turn on the stats_command_string option in postgresql.conf.
Regards,
Farhan
- Original Message
From: Sachchida Ojha <[EMAIL PROTECTED]>
To: pgsql-performa
[Sachchida Ojha - Wed at 04:40:09PM -0400]
> I see some long running transaction in my pg_activity_log table. My app
> becomes almost unusable. My question is
> How can I query the database to see what sql these transactions are
> running.
" in transaction" means that no sql query is running at
I can see SQL in the current SQL column of pg_activity_log when I run
sql from sql window or throgh odbc/jdbc connection but when sql is
embedded in java beaans i can see those sql. Is there any way to
extract those sql from the database.
16385;"em_db";20220;16388;"emsowner";"select * from
pg_
