How to show last queries in POSTGRES?

Question

What is query can I use for show last executed queries in DB PostgreSQL or where (files) can I find this? I use pgADMIN 3

Probably related: https://stackoverflow.com/questions/8208310/postgresql-how-to-see-which-queries-have-run — Oto Shavadze, Sep 21 '17 at 15:55
Use pg_stat_statements. Or set `log_statement = all` and use the log file. — Craig Ringer, Sep 21 '17 at 15:57

score 6 · Answer 1 · answered May 16 '19 at 18:45

6

For those on the command line using psql, you can view the command history with

\s

Or print it to a file with

\s filename

See also

answered May 16 '19 at 18:45

Suragch

score 1 · Accepted Answer · answered Sep 21 '17 at 15:38

1

See the History tab in the output pane.

You can find or change the location of the file under the File/Options... dialog.

answered Sep 21 '17 at 15:38

rd_nielsen

rd_nielsen I want to know all queries (include from remoute pcs) not only me from pgAdmin – Евгений Дружинин Sep 21 '17 at 15:47
As far as I know, there's no way to do that. The best approach may be to establish a discipline wherein all SQL commands are scripted, and scripts are run with a custom script executor that records the time that each statement is executed in a common logfile. – rd_nielsen Sep 21 '17 at 15:53
1

@rd_nielsen er... `log_statement = 'all'`, or use `pg_stat_statements` – Craig Ringer Sep 21 '17 at 15:58
@CraigRinger: Ah, of course -- that's the way to do it. – rd_nielsen Sep 21 '17 at 16:02

2 Answers2