Re: Insert query performance

Поиск
Список
Период
Сортировка
От Muhammad Ikram
Тема Re: Insert query performance
Дата
Msg-id CAGeimVqjCKdUp2fNYS_2FpE1OyXiue=dRu43MHzcG_SD7Kxw1Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Insert query performance  (sud <suds1434@gmail.com>)
Список pgsql-general
It will record all statements in logs. If you are concerned about query times then you may use pg_stat_statements.


Muhammad Ikram



On Tue, 20 Aug 2024 at 12:19, sud <suds1434@gmail.com> wrote:

On Mon, Aug 19, 2024 at 1:25 PM Muhammad Ikram <mmikram@gmail.com> wrote:
Hi Sud,

Please make following change in your postgresql.conf file

log_statement = 'all' 


Will this put all the internal sql query or the recursive query entries in the pg_stats_statement view which we can analyze then? And also to debug issues in the production will it be a good idea to set it for a few times and then turn it off or it can have significant performance overhead.

В списке pgsql-general по дате отправления: