Displaying current query - eliminating - Mailing list pgsql-novice

From Rieback Melanie
Subject Displaying current query - eliminating
Date
Msg-id Pine.GSO.4.56.0510220011270.19088@flits.few.vu.nl
Whole thread Raw
Responses Re: Displaying current query - eliminating
List pgsql-novice
This may come across as an odd question, but here goes..

To see the current query in PostgreSQL, the normal procedure is to type:
SELECT current_query FROM pg_stat_activity;

Now here's my question..    I want PostgreSQL to react sufficiently
quickly that the result says:

              current_query
-------------------------------------------
SELECT current_query FROM pg_stat_activity;
(1 row)

and not:

 current_query
---------------
 <IDLE>
(1 row)

In trying to achieve this behavior, I have taken the following actions:

In postgresql.conf:
stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
stats_reset_on_server_start = true

I also typed at the console:
\set pgstat_stat_interval 0;

This actually worked once, but since then, PostgreSQL has always reported
<IDLE>.  I've tried changing other environment variables, but with
no luck.  Nothing I've done so far has gotten it to respond consistently
in the quick-responding manner that I want.

Does anyone have any advice on how to achieve this desired behavior
consistantly?  I would be really appreciative if anyone had any tips.

Thanks!!!
Melanie R.

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Importing data
Next
From: Michael Glaesemann
Date:
Subject: Re: Database design advice