On Sun, Jan 13, 2013 at 02:17:34PM -0500, Vibhor Kumar wrote:
>
> On Jan 13, 2013, at 1:36 PM, AI Rumman wrote:
>
> > CREATE VIEW stats_slowest_queries AS
> >SELECT pg_stat_activity.procpid, (('now'::text)::timestamp(6) with time
> > zone - pg_stat_activity.query_start) AS execution_time,
>
On Jan 13, 2013, at 1:36 PM, AI Rumman wrote:
> CREATE VIEW stats_slowest_queries AS
>SELECT pg_stat_activity.procpid, (('now'::text)::timestamp(6) with time
> zone - pg_stat_activity.query_start) AS execution_time,
> pg_stat_activity.current_query FROM pg_stat_activity WHERE
> (pg_stat_acti