Technologies/PostgreSQL/blk_write_time
PostgreSQLPostgreSQLMetric

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)
autovacuum_vacuum_cost_delayrecommended: 2ms
Default delay between cost limit checks; -1 uses vacuum_cost_delay
autovacuum_vacuum_cost_limitrecommended: -1
Default uses vacuum_cost_limit; distributed among active workers
CLI Commands (1)
EXPLAIN ANALYZEdiagnostic
Technical References (2)
pg_stat_statementscomponentSection 20.4.4component
Related Insights (3)
Slow query performance degrades from milliseconds to secondswarning
▸
Autovacuum cost limits throttle vacuum during peak I/O periodsinfo
▸
VACUUM I/O traffic degrades concurrent query performancewarning
▸