# Question about performance impact when change log\_statement from ddl to all

**URL:** <https://forums.percona.com/t/question-about-performance-impact-when-change-log-statement-from-ddl-to-all/39655>\
**Category:** Percona Distribution for PostgreSQL\
**Tags:** percona\
**Created:** [October 30, 2025, 1:02am UTC](https://forums.percona.com/t/question-about-performance-impact-when-change-log-statement-from-ddl-to-all/39655 "2025-10-30T01:02:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cuongtm02](https://avatars.discourse-cdn.com/v4/letter/c/e68b1a/32.png) [@cuongtm02](https://forums.percona.com/u/cuongtm02)\
**Post date:** [October 30, 2025, 1:02am UTC](https://forums.percona.com/t/question-about-performance-impact-when-change-log-statement-from-ddl-to-all/39655/1 "2025-10-30T01:02:06Z")

</div>

Hi,

We plan to audit all action of Percona postgresql v17 by change log\_statement from ddl to all, please advise:

1/ performance impact, is there any document for compare performance when change this parameter for busy OLTP system

2/ Any extension or another solution for audit all action in Percona Postgresql?

---

<div class="post-metadata">

**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\
**Post date:** [October 30, 2025, 1:54pm UTC](https://forums.percona.com/t/question-about-performance-impact-when-change-log-statement-from-ddl-to-all/39655/2 "2025-10-30T13:54:04Z")

</div>

Hi cuongtm02,

1. The performance impact will be higher the bigger your workload (and depending QPS , query length and disk performance). You should do your benchmarks for your system/workload/hw

2. Not that I am aware of

Regards

---

<div class="post-metadata">

**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\
**Post date:** [October 30, 2025, 3:04pm UTC](https://forums.percona.com/t/question-about-performance-impact-when-change-log-statement-from-ddl-to-all/39655/3 "2025-10-30T15:04:07Z")

</div>

Hi,

Asking about performance when logging “everything” is an open question. As per the last posting it really depends on your system load. and the easiest way to test it is to use tools like iostat, dstat, top etc.

But another issue you need to consider in addition to load is space consumed by the logs.

It might be useful looking into these other runtime parameters as you consider your options:

- log\_min\_duration\_statement
- log\_min\_duration\_sample
- log\_statement\_sample\_rate
- log\_transaction\_sample\_rate
- log\_statement\_stats

Hope this helps 🙂