Re: pg_stat_statements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_stat_statements
Date
Msg-id 11737.1213372339@sss.pgh.pa.us
Whole thread Raw
In response to pg_stat_statements  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: pg_stat_statements  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Permission of prepared statements (was: pg_stat_statements)  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> 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.

We don't have any system-wide names for statements, so this seems
pretty ill-defined and of questionable value.  Showing the text of
statements in a view also has security problems.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: keyword list/ecpg
Next
From: Robert Treat
Date:
Subject: Re: Overhauling GUCS