Postgres Exporter 0.17.0 heavy default statement

From: kamal deen <kamaldeendba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres Exporter 0.17.0 heavy default statement
Date: 2025-11-20 10:10:57
Message-ID: CAAGAcEeDVSViqmabA97oxMhjPXGh=LLNx3OFJpwP-kb_o5n0sA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

Is anyone had face swap/memory or resource usage issue due to postgres
exporter.

We have observed one default select query part of exporter metrics which is
collecting some info from pg_stat_statment and calculating
percentile.(looks like heavy query). Suspecting our prod environment was
down due to that statement which caused heavy swap.noticed that this
statement creating temp files (was written in log file before it was
down).

Pls advice if any one come across this issue and share if any fix is
applied on this.

Postgres Version 16
Exporter Version 0.17.0
OS : Linux

Regards,
SK

Browse pgsql-admin by date

  From Date Subject
Next Message lejeczek 2025-11-20 14:16:35 What is paging my psql
Previous Message ek ek 2025-11-19 19:59:54 Re: rebuild big tables with pgrepack