pg_stat_acvtivity

From: Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: pg_stat_acvtivity
Date: 2015-01-11 12:29:35
Message-ID: CABnqL33SLOgUnXv6N2=TKdXgz+6N9n6OLSDwcTJ19AkHP+mBQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2015-01-11 13:47:46 Re: pg_stat_acvtivity
Previous Message Craig Ringer 2015-01-08 00:08:00 Re: Use a TEXT string which is an output from a function for executing a new query in postgres