Re: Best Table to find Query Logs.

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