public inbox for [email protected]  

help / color / mirror / Atom feed

work_mem memory usage statistics
2+ messages / 2 participants
[nested] [flat]

* work_mem memory usage statistics
@ 2024-10-15 18:45 Loles <[email protected]>
  2024-10-16 03:37 ` Re: work_mem memory usage statistics Muhammad Ikram <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Loles @ 2024-10-15 18:45 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>

Hi team,

Is there any statistics table or view in the PostgreSQL catalog, extension,
or similar that collects and displays work_mem memory usage statistics? It
would be interesting to know the use of the work_mem by user, application
and/or database.

Thanks in advance.

Loles


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: work_mem memory usage statistics
  2024-10-15 18:45 work_mem memory usage statistics Loles <[email protected]>
@ 2024-10-16 03:37 ` Muhammad Ikram <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Muhammad Ikram @ 2024-10-16 03:37 UTC (permalink / raw)
  To: Loles <[email protected]>; +Cc: Pgsql-admin <[email protected]>

Hi,

- No built-in routine or extension is there to show aggregation of work_mem
for any query, as it is dynamically allocated.
- If work_mem requirement exceeds then it spills to disk, which can be
monitored through logs. Use log_temp_files and log_statement_stats to see
temp files, their size may give clues.
- pg_stat_statements and pg_stat_activity may also help in getting an idea
about which queries are taking more time and their consumption of shared
blocks etc.

Regards,
Ikram

On Tue, Oct 15, 2024 at 11:46 PM Loles <[email protected]> wrote:

> Hi team,
>
> Is there any statistics table or view in the PostgreSQL catalog,
> extension, or similar that collects and displays work_mem memory usage
> statistics? It would be interesting to know the use of the work_mem by
> user, application and/or database.
>
> Thanks in advance.
>
> Loles
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-10-16 03:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-15 18:45 work_mem memory usage statistics Loles <[email protected]>
2024-10-16 03:37 ` Muhammad Ikram <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox