Re: pg_stat_acvtivity - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: pg_stat_acvtivity
Date
Msg-id CAFj8pRD+7ddrgPgpE2m51Oz8LqMf2kbxK0cah8=ekU7JtavmnA@mail.gmail.com
Whole thread Raw
In response to pg_stat_acvtivity  (Marcin Krawczyk <jankes.mk@gmail.com>)
List pgsql-sql
Hi

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);

pgsql-sql by date:

Previous
From: Marcin Krawczyk
Date:
Subject: pg_stat_acvtivity
Next
From: Dmitry Teslenko
Date:
Subject: fifo stock calculation with window function