explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hlsP

Settings
# exclusive inclusive rows x rows loops node
1. 3.847 79.231 ↓ 6.6 2,999 1

Nested Loop (cost=12.62..42,648.64 rows=453 width=279) (actual time=0.790..79.231 rows=2,999 loops=1)

2. 0.340 0.414 ↓ 210.0 210 1

Bitmap Heap Scan on metrics_labels l (cost=3.34..4.48 rows=1 width=263) (actual time=0.085..0.414 rows=210 loops=1)

  • Recheck Cond: (((metric_name = 'patching_state'::text) AND (patch_id_end_time >= (now() - '01:00:00'::interval)) AND (patch_id_end_time <= now())) OR ((metric_name = 'patching_state'::text) AND (start_time >= (now() - '01:00:00'::interval)) AND (start_time <= now())))
  • Filter: (((patch_id_end_time >= (now() - '01:00:00'::interval)) AND (patch_id_end_time <= now())) OR ((start_time >= (now() - '01:00:00'::interval)) AND (start_time <= now()) AND (patch_id_end_time IS NULL)))
  • Heap Blocks: exact=55
3. 0.002 0.074 ↓ 0.0 0 1

BitmapOr (cost=3.34..3.34 rows=1 width=0) (actual time=0.073..0.074 rows=0 loops=1)

4. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on metrics_labels_name_end_times_index (cost=0.00..1.55 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((metric_name = 'patching_state'::text) AND (patch_id_end_time >= (now() - '01:00:00'::interval)) AND (patch_id_end_time <= now()))
5. 0.057 0.057 ↓ 210.0 210 1

Bitmap Index Scan on metrics_labels_metric_name_new_idx (cost=0.00..1.80 rows=1 width=0) (actual time=0.057..0.057 rows=210 loops=1)

  • Index Cond: ((metric_name = 'patching_state'::text) AND (start_time >= (now() - '01:00:00'::interval)) AND (start_time <= now()))
6. 23.100 74.970 ↑ 2,531.6 14 210

Append (cost=9.27..42,289.74 rows=35,442 width=20) (actual time=0.330..0.357 rows=14 loops=210)

7. 0.210 0.840 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2357_chunk m (cost=9.27..633.40 rows=528 width=20) (actual time=0.004..0.004 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
8. 0.630 0.630 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2357_chunk_metrics_values_labels_id_idx (cost=0.00..9.14 rows=575 width=0) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
9. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2370_chunk m_1 (cost=9.66..686.12 rows=573 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
10. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2370_chunk_metrics_values_labels_id_idx (cost=0.00..9.52 rows=625 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
11. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2385_chunk_metrics_values_labels_id_idx on _hyper_14_2385_chunk m_2 (cost=0.43..433.82 rows=352 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
12. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2401_chunk_metrics_values_labels_id_idx on _hyper_14_2401_chunk m_3 (cost=0.43..378.79 rows=305 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
13. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2419_chunk_metrics_values_labels_id_idx on _hyper_14_2419_chunk m_4 (cost=0.43..409.77 rows=325 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
14. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2435_chunk_metrics_values_labels_id_idx on _hyper_14_2435_chunk m_5 (cost=0.43..338.74 rows=263 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
15. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2453_chunk_metrics_values_labels_id_idx on _hyper_14_2453_chunk m_6 (cost=0.43..415.44 rows=332 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
16. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2478_chunk m_7 (cost=9.28..636.44 rows=522 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
17. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2478_chunk_metrics_values_labels_id_idx (cost=0.00..9.15 rows=576 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
18. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2513_chunk m_8 (cost=11.29..763.94 rows=632 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
19. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2513_chunk_metrics_values_labels_id_idx (cost=0.00..11.13 rows=694 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
20. 0.630 0.630 ↓ 0.0 0 210

Index Scan using _hyper_14_2527_chunk_metrics_values_labels_id_idx on _hyper_14_2527_chunk m_9 (cost=0.43..480.38 rows=385 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
21. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2544_chunk_metrics_values_labels_id_idx on _hyper_14_2544_chunk m_10 (cost=0.43..397.48 rows=312 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
22. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2560_chunk_metrics_values_labels_id_idx on _hyper_14_2560_chunk m_11 (cost=0.43..362.17 rows=277 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
23. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2579_chunk_metrics_values_labels_id_idx on _hyper_14_2579_chunk m_12 (cost=0.43..379.78 rows=304 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
24. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2733_chunk_metrics_values_labels_id_idx on _hyper_14_2733_chunk m_13 (cost=0.43..401.70 rows=321 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
25. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2751_chunk m_14 (cost=9.13..615.64 rows=519 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
26. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2751_chunk_metrics_values_labels_id_idx (cost=0.00..9.00 rows=556 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
27. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2770_chunk m_15 (cost=9.24..630.86 rows=528 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
28. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2770_chunk_metrics_values_labels_id_idx (cost=0.00..9.11 rows=571 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
29. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2786_chunk_metrics_values_labels_id_idx on _hyper_14_2786_chunk m_16 (cost=0.43..503.11 rows=408 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
30. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2804_chunk_metrics_values_labels_id_idx on _hyper_14_2804_chunk m_17 (cost=0.43..413.43 rows=332 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
31. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2823_chunk_metrics_values_labels_id_idx on _hyper_14_2823_chunk m_18 (cost=0.43..409.22 rows=346 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
32. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2843_chunk_metrics_values_labels_id_idx on _hyper_14_2843_chunk m_19 (cost=0.43..334.75 rows=268 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
33. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2861_chunk_metrics_values_labels_id_idx on _hyper_14_2861_chunk m_20 (cost=0.43..367.35 rows=287 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
34. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2879_chunk m_21 (cost=7.66..561.96 rows=467 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
35. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2879_chunk_metrics_values_labels_id_idx (cost=0.00..7.55 rows=509 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
36. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_2897_chunk m_22 (cost=9.13..612.47 rows=511 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
37. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_2897_chunk_metrics_values_labels_id_idx (cost=0.00..9.00 rows=556 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
38. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2913_chunk_metrics_values_labels_id_idx on _hyper_14_2913_chunk m_23 (cost=0.43..422.02 rows=346 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
39. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2930_chunk_metrics_values_labels_id_idx on _hyper_14_2930_chunk m_24 (cost=0.43..362.13 rows=291 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
40. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2948_chunk_metrics_values_labels_id_idx on _hyper_14_2948_chunk m_25 (cost=0.43..359.78 rows=285 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
41. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2964_chunk_metrics_values_labels_id_idx on _hyper_14_2964_chunk m_26 (cost=0.43..414.03 rows=335 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
42. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_2982_chunk_metrics_values_labels_id_idx on _hyper_14_2982_chunk m_27 (cost=0.43..431.27 rows=365 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
43. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3000_chunk m_28 (cost=9.16..617.40 rows=539 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
44. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3000_chunk_metrics_values_labels_id_idx (cost=0.00..9.02 rows=559 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
45. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3018_chunk m_29 (cost=7.66..559.22 rows=485 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
46. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3018_chunk_metrics_values_labels_id_idx (cost=0.00..7.54 rows=508 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
47. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3037_chunk_metrics_values_labels_id_idx on _hyper_14_3037_chunk m_30 (cost=0.43..449.41 rows=383 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
48. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3056_chunk_metrics_values_labels_id_idx on _hyper_14_3056_chunk m_31 (cost=0.43..281.57 rows=230 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
49. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3075_chunk_metrics_values_labels_id_idx on _hyper_14_3075_chunk m_32 (cost=0.43..295.89 rows=232 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
50. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3092_chunk_metrics_values_labels_id_idx on _hyper_14_3092_chunk m_33 (cost=0.43..298.45 rows=242 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
51. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3109_chunk_metrics_values_labels_id_idx on _hyper_14_3109_chunk m_34 (cost=0.43..273.60 rows=224 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
52. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3128_chunk m_35 (cost=6.59..409.14 rows=338 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
53. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3128_chunk_metrics_values_labels_id_idx (cost=0.00..6.50 rows=370 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
54. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3148_chunk m_36 (cost=8.95..583.47 rows=494 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
55. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3148_chunk_metrics_values_labels_id_idx (cost=0.00..8.83 rows=533 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
56. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3165_chunk_metrics_values_labels_id_idx on _hyper_14_3165_chunk m_37 (cost=0.43..384.83 rows=315 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
57. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3187_chunk_metrics_values_labels_id_idx on _hyper_14_3187_chunk m_38 (cost=0.43..333.66 rows=273 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
58. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3206_chunk_metrics_values_labels_id_idx on _hyper_14_3206_chunk m_39 (cost=0.43..345.35 rows=282 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
59. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3224_chunk_metrics_values_labels_id_idx on _hyper_14_3224_chunk m_40 (cost=0.43..358.41 rows=291 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
60. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3243_chunk_metrics_values_labels_id_idx on _hyper_14_3243_chunk m_41 (cost=0.43..426.00 rows=333 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
61. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3265_chunk_metrics_values_labels_id_idx on _hyper_14_3265_chunk m_42 (cost=0.43..597.72 rows=475 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
62. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3285_chunk m_43 (cost=9.92..725.95 rows=617 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
63. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3285_chunk_metrics_values_labels_id_idx (cost=0.00..9.77 rows=658 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
64. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3305_chunk_metrics_values_labels_id_idx on _hyper_14_3305_chunk m_44 (cost=0.43..431.62 rows=361 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
65. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3325_chunk_metrics_values_labels_id_idx on _hyper_14_3325_chunk m_45 (cost=0.43..394.02 rows=330 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
66. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3346_chunk_metrics_values_labels_id_idx on _hyper_14_3346_chunk m_46 (cost=0.43..335.72 rows=283 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
67. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3365_chunk_metrics_values_labels_id_idx on _hyper_14_3365_chunk m_47 (cost=0.43..260.35 rows=228 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
68. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3386_chunk_metrics_values_labels_id_idx on _hyper_14_3386_chunk m_48 (cost=0.43..323.45 rows=275 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
69. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3408_chunk m_49 (cost=5.26..376.04 rows=324 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
70. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3408_chunk_metrics_values_labels_id_idx (cost=0.00..5.18 rows=340 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
71. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3428_chunk m_50 (cost=7.73..566.20 rows=498 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
72. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3428_chunk_metrics_values_labels_id_idx (cost=0.00..7.61 rows=517 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
73. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3448_chunk_metrics_values_labels_id_idx on _hyper_14_3448_chunk m_51 (cost=0.43..261.39 rows=223 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
74. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3468_chunk_metrics_values_labels_id_idx on _hyper_14_3468_chunk m_52 (cost=0.43..226.38 rows=188 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
75. 0.630 0.630 ↓ 0.0 0 210

Index Scan using _hyper_14_3489_chunk_metrics_values_labels_id_idx on _hyper_14_3489_chunk m_53 (cost=0.43..234.23 rows=185 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
76. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3512_chunk_metrics_values_labels_id_idx on _hyper_14_3512_chunk m_54 (cost=0.43..285.39 rows=240 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
77. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3533_chunk_metrics_values_labels_id_idx on _hyper_14_3533_chunk m_55 (cost=0.43..359.94 rows=289 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
78. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3554_chunk_metrics_values_labels_id_idx on _hyper_14_3554_chunk m_56 (cost=0.43..446.19 rows=361 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
79. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3576_chunk m_57 (cost=7.41..525.50 rows=432 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
80. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3576_chunk_metrics_values_labels_id_idx (cost=0.00..7.30 rows=476 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
81. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3597_chunk_metrics_values_labels_id_idx on _hyper_14_3597_chunk m_58 (cost=0.43..296.47 rows=239 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
82. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3620_chunk_metrics_values_labels_id_idx on _hyper_14_3620_chunk m_59 (cost=0.43..284.70 rows=230 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
83. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3641_chunk_metrics_values_labels_id_idx on _hyper_14_3641_chunk m_60 (cost=0.43..343.73 rows=266 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
84. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3663_chunk_metrics_values_labels_id_idx on _hyper_14_3663_chunk m_61 (cost=0.43..273.58 rows=230 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
85. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3685_chunk_metrics_values_labels_id_idx on _hyper_14_3685_chunk m_62 (cost=0.43..260.90 rows=221 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
86. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3707_chunk m_63 (cost=7.34..514.64 rows=450 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
87. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3707_chunk_metrics_values_labels_id_idx (cost=0.00..7.22 rows=466 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
88. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3729_chunk m_64 (cost=9.59..674.98 rows=604 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
89. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3729_chunk_metrics_values_labels_id_idx (cost=0.00..9.44 rows=615 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
90. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3750_chunk_metrics_values_labels_id_idx on _hyper_14_3750_chunk m_65 (cost=0.43..283.88 rows=244 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
91. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3771_chunk_metrics_values_labels_id_idx on _hyper_14_3771_chunk m_66 (cost=0.43..302.01 rows=264 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
92. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3792_chunk_metrics_values_labels_id_idx on _hyper_14_3792_chunk m_67 (cost=0.43..207.60 rows=190 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
93. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3817_chunk_metrics_values_labels_id_idx on _hyper_14_3817_chunk m_68 (cost=0.43..288.05 rows=249 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
94. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3838_chunk_metrics_values_labels_id_idx on _hyper_14_3838_chunk m_69 (cost=0.43..282.50 rows=232 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
95. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3850_chunk_metrics_values_labels_id_idx on _hyper_14_3850_chunk m_70 (cost=0.43..424.87 rows=334 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
96. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_3882_chunk m_71 (cost=8.95..587.15 rows=502 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
97. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_3882_chunk_metrics_values_labels_id_idx (cost=0.00..8.82 rows=532 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
98. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3903_chunk_metrics_values_labels_id_idx on _hyper_14_3903_chunk m_72 (cost=0.43..389.90 rows=314 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
99. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3921_chunk_metrics_values_labels_id_idx on _hyper_14_3921_chunk m_73 (cost=0.43..249.93 rows=178 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
100. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3929_chunk_metrics_values_labels_id_idx on _hyper_14_3929_chunk m_74 (cost=0.43..276.35 rows=233 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
101. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3965_chunk_metrics_values_labels_id_idx on _hyper_14_3965_chunk m_75 (cost=0.43..298.44 rows=252 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
102. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_3986_chunk_metrics_values_labels_id_idx on _hyper_14_3986_chunk m_76 (cost=0.43..422.80 rows=362 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
103. 0.630 0.630 ↓ 0.0 0 210

Index Scan using _hyper_14_4005_chunk_metrics_values_labels_id_idx on _hyper_14_4005_chunk m_77 (cost=0.43..449.29 rows=390 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
104. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_4025_chunk m_78 (cost=7.71..566.38 rows=501 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
105. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_4025_chunk_metrics_values_labels_id_idx (cost=0.00..7.58 rows=514 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
106. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4044_chunk_metrics_values_labels_id_idx on _hyper_14_4044_chunk m_79 (cost=0.43..480.13 rows=417 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
107. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4063_chunk_metrics_values_labels_id_idx on _hyper_14_4063_chunk m_80 (cost=0.43..440.24 rows=359 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
108. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4085_chunk_metrics_values_labels_id_idx on _hyper_14_4085_chunk m_81 (cost=0.43..561.49 rows=487 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
109. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4104_chunk_metrics_values_labels_id_idx on _hyper_14_4104_chunk m_82 (cost=0.43..542.49 rows=470 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
110. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4123_chunk_metrics_values_labels_id_idx on _hyper_14_4123_chunk m_83 (cost=0.43..510.02 rows=443 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
111. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4144_chunk_metrics_values_labels_id_idx on _hyper_14_4144_chunk m_84 (cost=0.43..636.48 rows=557 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
112. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_4163_chunk m_85 (cost=9.64..686.58 rows=607 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
113. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_4163_chunk_metrics_values_labels_id_idx (cost=0.00..9.49 rows=621 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
114. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4183_chunk_metrics_values_labels_id_idx on _hyper_14_4183_chunk m_86 (cost=0.43..525.59 rows=458 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
115. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4202_chunk_metrics_values_labels_id_idx on _hyper_14_4202_chunk m_87 (cost=0.43..562.66 rows=496 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
116. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4220_chunk_metrics_values_labels_id_idx on _hyper_14_4220_chunk m_88 (cost=0.43..694.75 rows=615 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
117. 0.630 0.630 ↓ 0.0 0 210

Index Scan using _hyper_14_4238_chunk_metrics_values_labels_id_idx on _hyper_14_4238_chunk m_89 (cost=0.43..490.96 rows=430 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
118. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_4256_chunk m_90 (cost=6.98..465.01 rows=410 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
119. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_4256_chunk_metrics_values_labels_id_idx (cost=0.00..6.88 rows=420 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
120. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_4275_chunk m_91 (cost=9.56..671.74 rows=601 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
121. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_4275_chunk_metrics_values_labels_id_idx (cost=0.00..9.41 rows=611 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
122. 0.420 0.840 ↓ 0.0 0 210

Bitmap Heap Scan on _hyper_14_4296_chunk m_92 (cost=7.57..547.67 rows=486 width=20) (actual time=0.004..0.004 rows=0 loops=210)

  • Recheck Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
123. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on _hyper_14_4296_chunk_metrics_values_labels_id_idx (cost=0.00..7.45 rows=496 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
124. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4315_chunk_metrics_values_labels_id_idx on _hyper_14_4315_chunk m_93 (cost=0.43..250.93 rows=212 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
125. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4335_chunk_metrics_values_labels_id_idx on _hyper_14_4335_chunk m_94 (cost=0.43..324.03 rows=274 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
126. 0.630 0.630 ↓ 0.0 0 210

Index Scan using _hyper_14_4356_chunk_metrics_values_labels_id_idx on _hyper_14_4356_chunk m_95 (cost=0.43..382.13 rows=333 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
127. 0.420 0.420 ↓ 0.0 0 210

Index Scan using _hyper_14_4382_chunk_metrics_values_labels_id_idx on _hyper_14_4382_chunk m_96 (cost=0.43..313.63 rows=269 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
128. 4.620 4.620 ↑ 24.6 14 210

Index Scan using _hyper_14_4410_chunk_metrics_values_labels_id_idx on _hyper_14_4410_chunk m_97 (cost=0.43..402.61 rows=344 width=20) (actual time=0.006..0.022 rows=14 loops=210)

  • Index Cond: (labels_id = l.id)
  • Filter: (value > '0'::double precision)
Planning time : 6.088 ms
Execution time : 80.986 ms