Technologies/PostgreSQL/postgresql.blk_write_time
PostgreSQLPostgreSQLMetric

postgresql.blk_write_time

Block write time
Dimensions:None
Available on:DatadogDatadog (2)Native (2)PrometheusPrometheus (1)
Interface Metrics (5)
DatadogDatadog
Total time spent writing blocks per query_signature, db, and user. (DBM only)
Dimensions:None
DatadogDatadog
Time spent writing data file blocks by backends in this database if track_io_timing is enabled. This metric is tagged with db.
Dimensions:None
Native
Time spent writing WAL to disk (ms)
Dimensions:None
Native
Time spent writing data file blocks (ms)
Dimensions:None
PrometheusPrometheus
Time spent writing data file blocks by backends in this database, in milliseconds
Dimensions:None
Sources
postgresql.queries.blk_write_timegithub.com
postgresql.blk_write_timegithub.com
wal_write_timegithub.com
blk_write_timegithub.com
stat_database_blk_write_timegithub.com

Technical Annotations (5)

Configuration Parameters (2)
track_io_timingrecommended: on
enables collection of I/O timing statistics in pg_stat_statements
track_wal_io_timingrecommended: off
default is off due to potential overhead; enable only after testing
CLI Commands (1)
pg_test_timingdiagnostic
Technical References (2)
pg_stat_statementscomponentpg_test_timingcomponent
Related Insights (2)
IO timing statistics unavailable without track_io_timing enabledinfo
▸
I/O timing overhead causes significant performance degradation on some platformswarning
▸