Re: Best Table to find Query Logs.

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: G N <myterag(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Jon Roberts <GreenplumGuru(at)gmail(dot)com>
Subject: Re: Best Table to find Query Logs.
Date: 2013-07-04 15:32:44
Message-ID: 51D5959C.7090806@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/04/2013 12:51 AM, G N wrote:
> Dear All,
>
> Hope you are doing well.
>
> I wanted to find out the suspicious queries run by users. Can you please
> suggest the best system table in PG/ Greenplum to find out such ?
>
> Appreciate your quick response.

http://www.postgresql.org/docs/9.2/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE

Table 27-2. pg_stat_activity View

>
> Regards,
> Girish

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-07-04 15:40:57 Re: Can't create plpython language
Previous Message David Johnston 2013-07-04 14:22:08 Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?