Re: pg_stat_statements

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_stat_statements
Date: 2008-06-13 16:58:22
Message-ID: 4852A72E.3040909@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-06-13 17:24:52 Re: pg_stat_statements
Previous Message David E. Wheeler 2008-06-13 16:51:25 Re: Better default_statistics_target