Re: [HACKERS] too short string for SQL in pg_stat_backend_activity

2004-08-17 Thread Tom Lane
Pavel Stehule <[EMAIL PROTECTED]> writes: > Can I set somewhere an long for text, which is in current_query in > "pg_catalog.pg_stat_activity"? No. You could attach gdb to the backend that's running the troublesome query and do "p debug_query_string" ... regards, tom lan

[HACKERS] too short string for SQL in pg_stat_backend_activity

2004-08-17 Thread Pavel Stehule
Hello I my work I have problem with some ugly SQL. Processing some query takes 2 days and more (problem is in queries not in PostgreSQL). I can't wait on end of query and can't take text of query from serverlog. Text of queries has about 2 - 7 Kb. I have problem identifi queries in our is, beco