Postgres Exporter 0.17.0 heavy default statement - Mailing list pgsql-admin

From kamal deen
Subject Postgres Exporter 0.17.0 heavy default statement
Date
Msg-id CAAGAcEeDVSViqmabA97oxMhjPXGh=LLNx3OFJpwP-kb_o5n0sA@mail.gmail.com
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: ek ek
Date:
Subject: Re: rebuild big tables with pgrepack
Next
From: lejeczek
Date:
Subject: What is paging my psql