Query execution time log, PostgreSQL?

Question

Objective: I have thousands of data, I want to know how to have a record of all the queries and the time it takes to complete each query.

Any suggestions what I should investigate? I've seen about pg_stat_activity. I am fully available to nurture myself, I would appreciate any documentation, since I only have basic knowledge.

PD: Thanks.

snakecharmerb · Accepted Answer · 2021-06-09 14:37:13Z

1

There is a log_min_duration_statement setting in the postgresql.conf file that defines a minimum duration, after which the duration and statement will be logged. If set to zero, all statements and durations are logged.

One should take care that using this setting does not consume too much disk space.

answered Jun 9, 2021 at 14:37

snakecharmerb

57.2k13 gold badges137 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Apolo Over a year ago

Thank u, i'll try, what do you think of pg_stat_statement?

snakecharmerb Over a year ago

I haven't used pg_stat_statement, so I don't have an opinion about it.

Collectives™ on Stack Overflow

Query execution time log, PostgreSQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related