logging queries and time used - Mailing list pgsql-general

From stig erikson
Subject logging queries and time used
Date
Msg-id cluc5g$2g0o$1@news.hub.org
Whole thread Raw
Responses Re: logging queries and time used
List pgsql-general
Hi.
i would like to log every single query coming in to the database into a
table. i would like the log to include the entire query and execution
time and execution cost, and if possible the user that executed the query.

A trigger is what i was thinking of, but how can i find out the actual
query, the time it took to execute it, etc.?

stig

pgsql-general by date:

Previous
From: Edmund Bacon
Date:
Subject: Re: adding missing FROM-clause
Next
From: GreyGeek
Date:
Subject: Re: PostgreSQL on Windows