Postgres Pro
Downloads
Home   >   mailing lists

Re: How should we design our tables and indexes - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: How should we design our tables and indexes
Date
Msg-id CAKAnmm+qd2NF0R6_m3AwDc9+OEPdiW96NY4p2CXbocAUSPQyhQ@mail.gmail.com
Whole thread Raw
In response to Re: How should we design our tables and indexes  (veem v <veema0000@gmail.com>)
List pgsql-general
Tree view
> Is there any way to track those historical executions and be able to find the exact root cause of the slow executions confidently?

https://www.postgresql.org/docs/current/auto-explain.html

auto_explain.log_min_duration = '5s' ## or large enough to capture your quickest one

Do NOT enable auto_explain.log_analyze.

Cheers,
Greg


pgsql-general by date:

Previous
From: veem v
Date:
Subject: Re: How should we design our tables and indexes
Next
From: veem v
Date:
Subject: Re: How to do faster DML