track stat - Search results
Blog >> PostgreSQL
Queries in PostgreSQL: 4. Index scan
stats WHERE tablename = 'bookings' ORDER BY abs(correlation) DESC; attname | correlation −−−−−−
Blog >> PostgreSQL
PostgreSQL 18: part 4 or CommitFest 2025-01
tracking WAL statistics in pg_stat_io . WAL operations are tracked across various processes, and within
Blog >> Postgres Pro Enterprise
What's New in Postgres Pro Enterprise 17: From Proxima to Intelligent Data Management
track changes in cluster topology and ensures that write requests always reach the correct node. Load balancing (under development). Proxima monitors loads on replicas and dynamically distributes incoming connections among the replicas. This prevents overloading
Blog >> PostgreSQL
PostgreSQL 18: part 2 or CommitFest 2024-09
stat_checkpointer.buffers_written tracks only shared buffers. To fix it, the developers split the information
Blog >> PostgreSQL
PostgreSQL 17: part 5 or CommitFest 2024-03
tracking the causes of replication conflicts commit: 007693f2 , 6ae701b4 In the pg_stat_replication view
Blog >> PostgreSQL
PostgreSQL 17: part 3 or CommitFest 2023-11
stat_statements: track statement entry timestamps and reset min/max statistics pg_stat_checkpointer: checkpointer process
Blog >> PostgreSQL
PostgreSQL 17: part 1 or CommitFest 2023-07
stat_progress_vacuum in such cases was leaving a lot to be desired. After all, thanks to the visibility map, vacuuming of the table itself affects only the pages that were changed since the previous
Blog >> PostgreSQL
PostgreSQL 16: part 5 or CommitFest 2023-03
tracked separately (as in pg_stat_io ), but rather are simply added to buffers_backend
Blog >> PostgreSQL
PostgreSQL 16: part 3 or CommitFest 2022-11
Tracking last scan time of indexes and tables pg_buffercache: a new function pg_buffercache_summary walsender displays the database name in the process status Reducing the WAL overhead of freezing tuples Reduced power consumption
Blog >> PostgreSQL
Battles in the ZFS Field
stat_activity WHERE state LIKE '%idle%' ORDER BY now() – xact_start DESC NULLS LAST ; Some of these transactions were also hung for hours. At this stage, it also became possible
Blog >> PostgreSQL
А deep dive into PostgreSQL query optimizations
tracking time and resource-consuming queries is presented below: pg_stat_statements can be used
Blog >> PostgreSQL
Locks in PostgreSQL: 4. Locks in memory
stat_activity a ON p.pid = a.pid WHERE a.application_name = 'pgbench' ORDER BY p.pid, p.count DESC; pid | backend_type | app | event_type | event | count -------+----------------+---------+------------+----------------+------- 29240 | client backend | pgbench | IO | WALWrite
Blog >> PostgreSQL
Locks in PostgreSQL: 3. Other locks
track locks automatically. The check, however, requires a certain effort, and it's undesirable to make it each time a new lock is requested (deadlocks are pretty infrequent after all). So, when a process tries
Blog >> PostgreSQL
Locks in PostgreSQL: 1. Relation-level locks
stat_activity WHERE pid = ANY(pg_blocking_pids(4782)) \gx -[ RECORD 1 ]----+------------------------------------------------------------ datid | 16386 datname | test pid | 4746 usesysid | 16384 usename | student application_name | psql client_addr | client_hostname | client_port | -1 backend_start | 2019
Blog >> PostgreSQL
PostgreSQL performance issue investigation with pg_profile
stat_kcache extensions . This approach has the following advantages: Tracking all queries regardless of a single