Re: pg_stat_statements - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: pg_stat_statements
Date
Msg-id 4852A72E.3040909@agliodbs.com
Whole thread Raw
In response to pg_stat_statements  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: pg_stat_statements  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
ITAGAKI Takahiro wrote:
> Hello,
> 
> Postgres 8.4 has pg_stat_user_functions view to track number of calls of
> stored functions and time spent in them. Then, I'm thinking a "sql statement"
> version of similar view -- pg_stat_statements.

I can see how this would be useful, but I can also see that it could be a
huge performance burden when activated.  So it couldn't be part of the
standard statistics collection.

--Josh



pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Better default_statistics_target
Next
From: Simon Riggs
Date:
Subject: Re: pg_stat_statements