explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ObCE

Settings
# exclusive inclusive rows x rows loops node
1. 0.646 31.922 ↓ 9.0 1,805 1

Sort (cost=36,645.97..36,646.47 rows=200 width=48) (actual time=31.806..31.922 rows=1,805 loops=1)

  • Sort Key: (first(_hyper_1_1_chunk.position_ts, _hyper_1_1_chunk.position_ts))
  • Sort Method: quicksort Memory: 190kB
2. 10.523 31.276 ↓ 9.0 1,805 1

HashAggregate (cost=36,633.32..36,638.32 rows=200 width=48) (actual time=29.428..31.276 rows=1,805 loops=1)

  • Group Key: time_bucket('00:05:00'::interval, _hyper_1_1_chunk.position_ts)
3. 1.719 20.753 ↑ 5.8 6,051 1

Result (cost=0.43..36,279.75 rows=35,357 width=32) (actual time=0.026..20.753 rows=6,051 loops=1)

4. 0.760 19.034 ↑ 5.8 6,051 1

Append (cost=0.43..35,837.79 rows=35,357 width=24) (actual time=0.025..19.034 rows=6,051 loops=1)

5. 0.159 0.159 ↑ 1.9 367 1

Index Scan using _hyper_1_1_chunk_position_reorder_chunk_idx on _hyper_1_1_chunk (cost=0.43..718.92 rows=714 width=24) (actual time=0.024..0.159 rows=367 loops=1)

  • Index Cond: (mean_id = 31592)
6. 0.875 0.875 ↑ 2.8 252 1

Index Scan using _hyper_1_2_chunk_position_reorder_chunk_idx on _hyper_1_2_chunk (cost=0.43..702.61 rows=697 width=24) (actual time=0.405..0.875 rows=252 loops=1)

  • Index Cond: (mean_id = 31592)
7. 0.654 0.654 ↑ 1.2 475 1

Index Scan using _hyper_1_3_chunk_position_reorder_chunk_idx on _hyper_1_3_chunk (cost=0.43..564.22 rows=560 width=24) (actual time=0.224..0.654 rows=475 loops=1)

  • Index Cond: (mean_id = 31592)
8. 0.287 0.287 ↑ 23.9 25 1

Index Scan using _hyper_1_4_chunk_position_reorder_chunk_idx on _hyper_1_4_chunk (cost=0.43..601.83 rows=597 width=24) (actual time=0.279..0.287 rows=25 loops=1)

  • Index Cond: (mean_id = 31592)
9. 0.559 0.559 ↑ 4.0 185 1

Index Scan using _hyper_1_5_chunk_position_reorder_chunk_idx on _hyper_1_5_chunk (cost=0.43..752.44 rows=747 width=24) (actual time=0.212..0.559 rows=185 loops=1)

  • Index Cond: (mean_id = 31592)
10. 0.694 0.694 ↑ 2.0 315 1

Index Scan using _hyper_1_6_chunk_position_reorder_chunk_idx on _hyper_1_6_chunk (cost=0.43..638.43 rows=633 width=24) (actual time=0.239..0.694 rows=315 loops=1)

  • Index Cond: (mean_id = 31592)
11. 1.000 1.000 ↓ 1.7 1,160 1

Index Scan using _hyper_1_7_chunk_position_reorder_chunk_idx on _hyper_1_7_chunk (cost=0.43..702.11 rows=696 width=24) (actual time=0.242..1.000 rows=1,160 loops=1)

  • Index Cond: (mean_id = 31592)
12. 0.608 0.608 ↑ 1.6 428 1

Index Scan using _hyper_1_8_chunk_position_reorder_chunk_idx on _hyper_1_8_chunk (cost=0.43..698.56 rows=693 width=24) (actual time=0.236..0.608 rows=428 loops=1)

  • Index Cond: (mean_id = 31592)
13. 0.279 0.279 ↑ 2.8 214 1

Index Scan using _hyper_1_9_chunk_position_reorder_chunk_idx on _hyper_1_9_chunk (cost=0.43..610.96 rows=606 width=24) (actual time=0.210..0.279 rows=214 loops=1)

  • Index Cond: (mean_id = 31592)
14. 0.829 0.829 ↓ 1.2 712 1

Index Scan using _hyper_1_10_chunk_position_reorder_chunk_idx on _hyper_1_10_chunk (cost=0.43..575.08 rows=571 width=24) (actual time=0.235..0.829 rows=712 loops=1)

  • Index Cond: (mean_id = 31592)
15. 0.245 0.245 ↓ 0.0 0 1

Index Scan using _hyper_1_11_chunk_position_reorder_chunk_idx on _hyper_1_11_chunk (cost=0.43..722.78 rows=717 width=24) (actual time=0.244..0.245 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
16. 0.266 0.266 ↓ 0.0 0 1

Index Scan using _hyper_1_12_chunk_position_reorder_chunk_idx on _hyper_1_12_chunk (cost=0.43..651.61 rows=646 width=24) (actual time=0.266..0.266 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
17. 0.233 0.233 ↓ 0.0 0 1

Index Scan using _hyper_1_13_chunk_position_reorder_chunk_idx on _hyper_1_13_chunk (cost=0.43..746.43 rows=742 width=24) (actual time=0.233..0.233 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
18. 0.217 0.217 ↓ 0.0 0 1

Index Scan using _hyper_1_14_chunk_position_reorder_chunk_idx on _hyper_1_14_chunk (cost=0.43..702.59 rows=697 width=24) (actual time=0.217..0.217 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
19. 0.212 0.212 ↓ 0.0 0 1

Index Scan using _hyper_1_15_chunk_position_reorder_chunk_idx on _hyper_1_15_chunk (cost=0.43..726.30 rows=721 width=24) (actual time=0.211..0.212 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
20. 0.214 0.214 ↓ 0.0 0 1

Index Scan using _hyper_1_16_chunk_position_reorder_chunk_idx on _hyper_1_16_chunk (cost=0.43..672.05 rows=667 width=24) (actual time=0.213..0.214 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
21. 0.211 0.211 ↓ 0.0 0 1

Index Scan using _hyper_1_17_chunk_position_reorder_chunk_idx on _hyper_1_17_chunk (cost=0.43..722.96 rows=718 width=24) (actual time=0.211..0.211 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
22. 0.011 0.011 ↓ 0.0 0 1

Index Scan using _hyper_1_18_chunk_position_reorder_chunk_idx on _hyper_1_18_chunk (cost=0.43..691.35 rows=686 width=24) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
23. 0.209 0.209 ↓ 0.0 0 1

Index Scan using _hyper_1_19_chunk_position_reorder_chunk_idx on _hyper_1_19_chunk (cost=0.43..713.57 rows=707 width=24) (actual time=0.209..0.209 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
24. 0.240 0.240 ↓ 0.0 0 1

Index Scan using _hyper_1_23_chunk_position_reorder_chunk_idx on _hyper_1_23_chunk (cost=0.43..705.67 rows=700 width=24) (actual time=0.240..0.240 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
25. 0.235 0.235 ↓ 0.0 0 1

Index Scan using _hyper_1_24_chunk_position_reorder_chunk_idx on _hyper_1_24_chunk (cost=0.43..733.77 rows=729 width=24) (actual time=0.235..0.235 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
26. 0.209 0.209 ↓ 0.0 0 1

Index Scan using _hyper_1_25_chunk_position_reorder_chunk_idx on _hyper_1_25_chunk (cost=0.43..708.75 rows=704 width=24) (actual time=0.209..0.209 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
27. 0.961 0.961 ↓ 1.0 704 1

Index Scan using _hyper_1_26_chunk_position_reorder_chunk_idx on _hyper_1_26_chunk (cost=0.43..704.18 rows=700 width=24) (actual time=0.209..0.961 rows=704 loops=1)

  • Index Cond: (mean_id = 31592)
28. 0.270 0.270 ↓ 0.0 0 1

Index Scan using _hyper_1_27_chunk_position_reorder_chunk_idx on _hyper_1_27_chunk (cost=0.43..603.68 rows=599 width=24) (actual time=0.270..0.270 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
29. 0.257 0.257 ↓ 0.0 0 1

Index Scan using _hyper_1_28_chunk_position_reorder_chunk_idx on _hyper_1_28_chunk (cost=0.43..549.97 rows=546 width=24) (actual time=0.257..0.257 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
30. 0.289 0.289 ↓ 0.0 0 1

Index Scan using _hyper_1_29_chunk_position_reorder_chunk_idx on _hyper_1_29_chunk (cost=0.43..653.74 rows=648 width=24) (actual time=0.289..0.289 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
31. 0.247 0.247 ↓ 0.0 0 1

Index Scan using _hyper_1_30_chunk_position_reorder_chunk_idx on _hyper_1_30_chunk (cost=0.43..645.62 rows=640 width=24) (actual time=0.247..0.247 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
32. 0.211 0.211 ↓ 0.0 0 1

Index Scan using _hyper_1_32_chunk_position_reorder_chunk_idx on _hyper_1_32_chunk (cost=0.43..681.26 rows=676 width=24) (actual time=0.211..0.211 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
33. 0.233 0.233 ↓ 0.0 0 1

Index Scan using _hyper_1_33_chunk_position_reorder_chunk_idx on _hyper_1_33_chunk (cost=0.43..693.43 rows=688 width=24) (actual time=0.233..0.233 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
34. 0.203 0.203 ↓ 0.0 0 1

Index Scan using _hyper_1_35_chunk_position_reorder_chunk_idx on _hyper_1_35_chunk (cost=0.43..626.29 rows=621 width=24) (actual time=0.203..0.203 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
35. 0.208 0.208 ↓ 0.0 0 1

Index Scan using _hyper_1_36_chunk_position_reorder_chunk_idx on _hyper_1_36_chunk (cost=0.43..625.26 rows=619 width=24) (actual time=0.208..0.208 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
36. 0.210 0.210 ↓ 0.0 0 1

Index Scan using _hyper_1_37_chunk_position_reorder_chunk_idx on _hyper_1_37_chunk (cost=0.43..663.38 rows=657 width=24) (actual time=0.210..0.210 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
37. 0.200 0.200 ↓ 0.0 0 1

Index Scan using _hyper_1_38_chunk_position_reorder_chunk_idx on _hyper_1_38_chunk (cost=0.43..637.15 rows=631 width=24) (actual time=0.200..0.200 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
38. 0.232 0.232 ↓ 0.0 0 1

Index Scan using _hyper_1_39_chunk_position_reorder_chunk_idx on _hyper_1_39_chunk (cost=0.43..650.70 rows=644 width=24) (actual time=0.232..0.232 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
39. 0.208 0.208 ↓ 0.0 0 1

Index Scan using _hyper_1_40_chunk_position_reorder_chunk_idx on _hyper_1_40_chunk (cost=0.43..628.26 rows=622 width=24) (actual time=0.208..0.208 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
40. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on _hyper_1_41_chunk (cost=0.00..1.01 rows=1 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (mean_id = 31592)
  • Rows Removed by Filter: 1
41. 0.224 0.224 ↓ 0.0 0 1

Index Scan using _hyper_1_42_chunk_position_reorder_chunk_idx on _hyper_1_42_chunk (cost=0.43..654.77 rows=648 width=24) (actual time=0.224..0.224 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
42. 0.207 0.207 ↓ 0.0 0 1

Index Scan using _hyper_1_44_chunk_position_reorder_chunk_idx on _hyper_1_44_chunk (cost=0.43..656.80 rows=650 width=24) (actual time=0.207..0.207 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
43. 0.208 0.208 ↓ 0.0 0 1

Index Scan using _hyper_1_45_chunk_position_reorder_chunk_idx on _hyper_1_45_chunk (cost=0.43..666.95 rows=660 width=24) (actual time=0.207..0.208 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
44. 0.211 0.211 ↓ 0.0 0 1

Index Scan using _hyper_1_46_chunk_position_reorder_chunk_idx on _hyper_1_46_chunk (cost=0.43..688.35 rows=681 width=24) (actual time=0.211..0.211 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
45. 1.338 1.338 ↓ 1.1 686 1

Index Scan using _hyper_1_47_chunk_position_reorder_chunk_idx on _hyper_1_47_chunk (cost=0.43..613.02 rows=609 width=24) (actual time=0.209..1.338 rows=686 loops=1)

  • Index Cond: (mean_id = 31592)
46. 0.240 0.240 ↓ 0.0 0 1

Index Scan using _hyper_1_48_chunk_position_reorder_chunk_idx on _hyper_1_48_chunk (cost=0.43..599.70 rows=593 width=24) (actual time=0.240..0.240 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
47. 0.208 0.208 ↓ 0.0 0 1

Index Scan using _hyper_1_49_chunk_position_reorder_chunk_idx on _hyper_1_49_chunk (cost=0.43..700.48 rows=692 width=24) (actual time=0.208..0.208 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
48. 0.219 0.219 ↓ 0.0 0 1

Index Scan using _hyper_1_174_chunk_position_reorder_chunk_idx on _hyper_1_174_chunk (cost=0.43..691.19 rows=681 width=24) (actual time=0.219..0.219 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
49. 0.446 0.446 ↓ 0.0 0 1

Index Scan using _hyper_1_178_chunk_position_reorder_chunk_idx on _hyper_1_178_chunk (cost=0.43..723.20 rows=714 width=24) (actual time=0.446..0.446 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
50. 0.190 0.190 ↓ 0.0 0 1

Index Scan using _hyper_1_182_chunk_position_reorder_chunk_idx on _hyper_1_182_chunk (cost=0.43..680.13 rows=670 width=24) (actual time=0.190..0.190 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
51. 0.194 0.194 ↓ 0.0 0 1

Index Scan using _hyper_1_187_chunk_position_reorder_chunk_idx on _hyper_1_187_chunk (cost=0.43..700.44 rows=691 width=24) (actual time=0.194..0.194 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
52. 0.010 0.010 ↓ 0.0 0 1

Index Scan using _hyper_1_192_chunk_position_mean_id_idx on _hyper_1_192_chunk (cost=0.43..559.47 rows=571 width=24) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
53. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_197_chunk_position_mean_id_idx on _hyper_1_197_chunk (cost=0.43..523.90 rows=535 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
54. 0.214 0.214 ↓ 0.0 0 1

Index Scan using _hyper_1_202_chunk_position_reorder_chunk_idx on _hyper_1_202_chunk (cost=0.43..682.03 rows=673 width=24) (actual time=0.214..0.214 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
55. 0.214 0.214 ↓ 0.0 0 1

Index Scan using _hyper_1_207_chunk_position_reorder_chunk_idx on _hyper_1_207_chunk (cost=0.43..761.41 rows=751 width=24) (actual time=0.214..0.214 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
56. 0.196 0.196 ↓ 0.0 0 1

Index Scan using _hyper_1_213_chunk_position_reorder_chunk_idx on _hyper_1_213_chunk (cost=0.43..791.06 rows=780 width=24) (actual time=0.196..0.196 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
57. 0.233 0.233 ↓ 0.0 0 1

Index Scan using _hyper_1_248_chunk_position_reorder_chunk_idx on _hyper_1_248_chunk (cost=0.43..778.70 rows=767 width=24) (actual time=0.233..0.233 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
58. 1.528 1.528 ↑ 1.4 528 1

Index Scan using _hyper_1_270_chunk_position_reorder_chunk_idx on _hyper_1_270_chunk (cost=0.43..762.46 rows=751 width=24) (actual time=0.216..1.528 rows=528 loops=1)

  • Index Cond: (mean_id = 31592)
Planning time : 4.765 ms
Execution time : 32.400 ms