mirror of
https://github.com/neondatabase/neon.git
synced 2025-12-27 08:09:58 +00:00
8da4ec9740
https://github.com/neondatabase/neon/issues/10327 Resolves: #11720 New metrics: - `compute_getpage_stuck_requests_total` - `compute_getpage_max_inflight_stuck_time_ms`
22 lines
888 B
SQL
22 lines
888 B
SQL
WITH c AS (SELECT pg_catalog.jsonb_object_agg(metric, value) jb FROM neon.neon_perf_counters)
|
|
|
|
SELECT d.* FROM pg_catalog.jsonb_to_record((SELECT jb FROM c)) AS d(
|
|
file_cache_read_wait_seconds_count numeric,
|
|
file_cache_read_wait_seconds_sum numeric,
|
|
file_cache_write_wait_seconds_count numeric,
|
|
file_cache_write_wait_seconds_sum numeric,
|
|
getpage_wait_seconds_count numeric,
|
|
getpage_wait_seconds_sum numeric,
|
|
getpage_prefetch_requests_total numeric,
|
|
getpage_sync_requests_total numeric,
|
|
compute_getpage_stuck_requests_total numeric,
|
|
compute_getpage_max_inflight_stuck_time_ms numeric,
|
|
getpage_prefetch_misses_total numeric,
|
|
getpage_prefetch_discards_total numeric,
|
|
getpage_prefetches_buffered numeric,
|
|
pageserver_requests_sent_total numeric,
|
|
pageserver_disconnects_total numeric,
|
|
pageserver_send_flushes_total numeric,
|
|
pageserver_open_requests numeric
|
|
);
|