Home > mailing lists

pg_stat_acvtivity - Mailing list pgsql-sql

From	Marcin Krawczyk
Subject	pg_stat_acvtivity
Date	January 11, 2015 15:29:42
Msg-id	CABnqL33SLOgUnXv6N2=TKdXgz+6N9n6OLSDwcTJ19AkHP+mBQg@mail.gmail.com Whole thread Raw
Responses	Re: pg_stat_acvtivity (Pavel Stehule <pavel.stehule@gmail.com>)
List	pgsql-sql

Tree view

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:

From: Craig Ringer
Date: 08 January 2015, 03:08:13
Subject: Re: Use a TEXT string which is an output from a function for executing a new query in postgres

From: Pavel Stehule
Date: 11 January 2015, 16:48:36
Subject: Re: pg_stat_acvtivity

pg_stat_acvtivity - Mailing list pgsql-sql

Previous

Next