Thread: Best Table to find Query Logs.

Best Table to find Query Logs.

From

G N

Date:

04 July 2013, 17:38:22

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.

Regards,

Girish

Re: Best Table to find Query Logs.

From

Adrian Klaver

Date:

04 July 2013, 18:32:52

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