explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OgoS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=7,097,435.79..7,097,435.96 rows=10 width=80) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=7,097,435.79..7,097,713.04 rows=15,843 width=80) (actual rows= loops=)

  • Group Key: (l.labels ->> 'cms_id'::text), (l.labels ->> 'patch_id'::text)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,530.36..6,999,331.99 rows=7,848,304 width=80) (actual rows= loops=)

  • Hash Cond: (m.labels_id = l.id)
4. 0.000 0.000 ↓ 0.0

Append (cost=0.00..5,970,415.01 rows=360,815,101 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2357_chunk m (cost=0.00..53,963.47 rows=3,277,247 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2370_chunk m_1 (cost=0.00..53,793.40 rows=3,266,340 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2385_chunk m_2 (cost=0.00..56,124.46 rows=3,407,946 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2401_chunk m_3 (cost=0.00..64,664.75 rows=3,925,075 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2419_chunk m_4 (cost=0.00..65,538.42 rows=3,983,142 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2435_chunk m_5 (cost=0.00..73,450.02 rows=4,462,102 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2453_chunk m_6 (cost=0.00..67,047.68 rows=4,070,568 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2478_chunk m_7 (cost=0.00..65,526.61 rows=3,978,361 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2513_chunk m_8 (cost=0.00..64,560.17 rows=3,921,017 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2527_chunk m_9 (cost=0.00..66,338.33 rows=4,028,933 width=4) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2544_chunk m_10 (cost=0.00..63,243.95 rows=3,839,395 width=4) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2560_chunk m_11 (cost=0.00..67,254.82 rows=4,084,982 width=4) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2579_chunk m_12 (cost=0.00..71,415.28 rows=4,337,928 width=4) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2733_chunk m_13 (cost=0.00..72,419.85 rows=4,398,085 width=4) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2751_chunk m_14 (cost=0.00..67,680.74 rows=4,109,474 width=4) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2770_chunk m_15 (cost=0.00..64,252.34 rows=3,899,134 width=4) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2786_chunk m_16 (cost=0.00..63,290.18 rows=3,841,518 width=4) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2804_chunk m_17 (cost=0.00..62,718.62 rows=3,807,362 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2823_chunk m_18 (cost=0.00..76,276.77 rows=4,631,377 width=4) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2843_chunk m_19 (cost=0.00..72,077.85 rows=4,378,985 width=4) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2861_chunk m_20 (cost=0.00..63,448.15 rows=3,851,015 width=4) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2879_chunk m_21 (cost=0.00..54,253.93 rows=3,290,593 width=4) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2897_chunk m_22 (cost=0.00..53,083.41 rows=3,220,141 width=4) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2913_chunk m_23 (cost=0.00..55,774.05 rows=3,384,705 width=4) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2930_chunk m_24 (cost=0.00..61,685.43 rows=3,744,943 width=4) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2948_chunk m_25 (cost=0.00..70,562.93 rows=4,282,093 width=4) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2964_chunk m_26 (cost=0.00..65,861.96 rows=4,001,696 width=4) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_2982_chunk m_27 (cost=0.00..64,314.10 rows=3,906,910 width=4) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3000_chunk m_28 (cost=0.00..60,407.19 rows=3,667,219 width=4) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3018_chunk m_29 (cost=0.00..47,043.86 rows=2,852,286 width=4) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3037_chunk m_30 (cost=0.00..42,595.51 rows=2,582,251 width=4) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3056_chunk m_31 (cost=0.00..48,027.12 rows=2,914,112 width=4) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3075_chunk m_32 (cost=0.00..50,263.23 rows=3,053,223 width=4) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3092_chunk m_33 (cost=0.00..41,013.92 rows=2,487,092 width=4) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3109_chunk m_34 (cost=0.00..39,338.79 rows=2,385,179 width=4) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3128_chunk m_35 (cost=0.00..39,680.62 rows=2,405,162 width=4) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3148_chunk m_36 (cost=0.00..37,434.33 rows=2,267,333 width=4) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3165_chunk m_37 (cost=0.00..33,582.58 rows=2,032,158 width=4) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3187_chunk m_38 (cost=0.00..37,577.49 rows=2,275,349 width=4) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3206_chunk m_39 (cost=0.00..46,564.50 rows=2,821,450 width=4) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3224_chunk m_40 (cost=0.00..52,079.99 rows=3,159,599 width=4) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3243_chunk m_41 (cost=0.00..77,747.54 rows=4,723,654 width=4) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3265_chunk m_42 (cost=0.00..81,173.29 rows=4,931,829 width=4) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3285_chunk m_43 (cost=0.00..71,032.63 rows=4,310,263 width=4) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3305_chunk m_44 (cost=0.00..63,393.14 rows=3,850,214 width=4) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3325_chunk m_45 (cost=0.00..69,334.07 rows=4,211,607 width=4) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3346_chunk m_46 (cost=0.00..73,271.51 rows=4,448,451 width=4) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3365_chunk m_47 (cost=0.00..65,765.34 rows=3,992,334 width=4) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3386_chunk m_48 (cost=0.00..59,498.76 rows=3,611,676 width=4) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3408_chunk m_49 (cost=0.00..38,479.46 rows=2,331,846 width=4) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3428_chunk m_50 (cost=0.00..39,622.30 rows=2,401,230 width=4) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3448_chunk m_51 (cost=0.00..38,957.24 rows=2,362,424 width=4) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3468_chunk m_52 (cost=0.00..55,587.77 rows=3,377,177 width=4) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3489_chunk m_53 (cost=0.00..48,962.66 rows=2,973,266 width=4) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3512_chunk m_54 (cost=0.00..62,356.15 rows=3,784,315 width=4) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3533_chunk m_55 (cost=0.00..59,332.57 rows=3,603,457 width=4) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3554_chunk m_56 (cost=0.00..54,313.93 rows=3,295,693 width=4) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3576_chunk m_57 (cost=0.00..52,009.62 rows=3,154,662 width=4) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3597_chunk m_58 (cost=0.00..56,268.56 rows=3,414,456 width=4) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3620_chunk m_59 (cost=0.00..58,818.04 rows=3,569,404 width=4) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3641_chunk m_60 (cost=0.00..70,548.72 rows=4,284,772 width=4) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3663_chunk m_61 (cost=0.00..59,855.79 rows=3,629,779 width=4) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3685_chunk m_62 (cost=0.00..53,804.01 rows=3,264,201 width=4) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3707_chunk m_63 (cost=0.00..54,079.02 rows=3,283,202 width=4) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3729_chunk m_64 (cost=0.00..51,960.50 rows=3,153,150 width=4) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3750_chunk m_65 (cost=0.00..57,344.81 rows=3,480,381 width=4) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3771_chunk m_66 (cost=0.00..67,639.35 rows=4,105,235 width=4) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3792_chunk m_67 (cost=0.00..69,275.47 rows=4,215,447 width=4) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3817_chunk m_68 (cost=0.00..71,867.72 rows=4,373,872 width=4) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3838_chunk m_69 (cost=0.00..64,915.18 rows=3,925,318 width=4) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3850_chunk m_70 (cost=0.00..65,858.38 rows=3,981,238 width=4) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3882_chunk m_71 (cost=0.00..52,255.53 rows=3,150,953 width=4) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3903_chunk m_72 (cost=0.00..60,354.11 rows=3,647,711 width=4) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3921_chunk m_73 (cost=0.00..77,731.99 rows=4,711,599 width=4) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3929_chunk m_74 (cost=0.00..69,029.41 rows=4,134,841 width=4) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3965_chunk m_75 (cost=0.00..79,297.42 rows=4,760,642 width=4) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_3986_chunk m_76 (cost=0.00..90,967.53 rows=5,465,753 width=4) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4005_chunk m_77 (cost=0.00..76,024.83 rows=4,553,983 width=4) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4025_chunk m_78 (cost=0.00..52,693.08 rows=3,136,208 width=4) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4044_chunk m_79 (cost=0.00..62,070.07 rows=3,706,507 width=4) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4063_chunk m_80 (cost=0.00..77,691.61 rows=4,659,361 width=4) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4085_chunk m_81 (cost=0.00..68,864.20 rows=4,116,920 width=4) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4104_chunk m_82 (cost=0.00..68,871.21 rows=4,116,521 width=4) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4123_chunk m_83 (cost=0.00..69,015.22 rows=4,126,622 width=4) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4144_chunk m_84 (cost=0.00..72,704.34 rows=4,352,034 width=4) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4163_chunk m_85 (cost=0.00..73,559.89 rows=4,403,189 width=4) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4183_chunk m_86 (cost=0.00..75,725.01 rows=4,533,401 width=4) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4202_chunk m_87 (cost=0.00..77,964.48 rows=4,668,848 width=4) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4220_chunk m_88 (cost=0.00..78,797.72 rows=4,720,672 width=4) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4238_chunk m_89 (cost=0.00..54,874.20 rows=3,260,920 width=4) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4256_chunk m_90 (cost=0.00..51,269.94 rows=3,041,594 width=4) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4275_chunk m_91 (cost=0.00..50,743.79 rows=3,004,479 width=4) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4296_chunk m_92 (cost=0.00..52,570.76 rows=3,117,676 width=4) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4315_chunk m_93 (cost=0.00..56,133.32 rows=3,339,532 width=4) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4335_chunk m_94 (cost=0.00..58,149.90 rows=3,455,190 width=4) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4356_chunk m_95 (cost=0.00..57,086.63 rows=3,395,163 width=4) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4382_chunk m_96 (cost=0.00..59,051.14 rows=3,513,314 width=4) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Seq Scan on _hyper_14_4410_chunk m_97 (cost=0.00..57,613.35 rows=3,443,435 width=4) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Hash (cost=42,330.25..42,330.25 rows=16,009 width=236) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on metrics_labels l (cost=3,864.63..42,330.25 rows=16,009 width=236) (actual rows= loops=)

  • Recheck Cond: (metric_name = ANY ('{patching_state,version_id}'::text[]))
  • Filter: (((labels ->> 'patch_id'::text) <> ''::text) AND (((patch_id_end_time >= (now() - '7 days'::interval)) AND (patch_id_end_time <= now())) OR ((end_time >= (now() - '7 days'::interval)) AND (end_time <= now()))))
105. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on metrics_labels_metric_name_idx (cost=0.00..3,860.63 rows=281,144 width=0) (actual rows= loops=)

  • Index Cond: (metric_name = ANY ('{patching_state,version_id}'::text[]))