Home > mailing lists

Re: Best Table to find Query Logs. - Mailing list pgsql-general

From	Adrian Klaver
Subject	Re: Best Table to find Query Logs.
Date	July 4, 2013 18:32:52
Msg-id	51D5959C.7090806@gmail.com Whole thread Raw
In response to	Best Table to find Query Logs. (G N <myterag@gmail.com>)
List	pgsql-general

Tree view

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.klaver@gmail.com

pgsql-general by date:

From: G N
Date: 04 July 2013, 17:38:22
Subject: Best Table to find Query Logs.

From: Adrian Klaver
Date: 04 July 2013, 18:41:09
Subject: Re: Can't create plpython language

Re: Best Table to find Query Logs. - Mailing list pgsql-general

Previous

Next