Thread: pg_stat_acvtivity

pg_stat_acvtivity

From

Marcin Krawczyk

Date:

11 January 2015, 15:29:42

Hi list,

Is there a way to run a query that will not affect the pg_stat_activity's query_start column ? It shows the run time of the last query.

something like:

SET config_par(loggin_off);

SELECT * FROM foo;

SET config_par(logging_on);

Re: pg_stat_acvtivity

From

Pavel Stehule

Date:

11 January 2015, 16:48:36

It is not possible - what I know. You can run query via SPI interface, but still pg_stat_activity shows parent query.

Regards

Pavel

2015-01-11 13:29 GMT+01:00 Marcin Krawczyk <jankes.mk@gmail.com>:

Hi list,

Is there a way to run a query that will not affect the pg_stat_activity's query_start column ? It shows the run time of the last query.

something like:
SET config_par(loggin_off);
SELECT * FROM foo;
SET config_par(logging_on);