explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rzp

Settings
# exclusive inclusive rows x rows loops node
1. 0.469 17.572 ↓ 10.2 1,805 1

Sort (cost=40,299.96..40,300.40 rows=177 width=40) (actual time=17.447..17.572 rows=1,805 loops=1)

  • Sort Key: q.position_ts
  • Sort Method: quicksort Memory: 190kB
2. 0.930 17.103 ↓ 10.2 1,805 1

Subquery Scan on q (cost=38,879.07..40,293.35 rows=177 width=40) (actual time=7.487..17.103 rows=1,805 loops=1)

  • Filter: (q.idx = 1)
  • Rows Removed by Filter: 4246
3. 8.176 16.173 ↑ 5.8 6,051 1

WindowAgg (cost=38,879.07..39,851.38 rows=35,357 width=56) (actual time=7.485..16.173 rows=6,051 loops=1)

4. 2.703 7.997 ↑ 5.8 6,051 1

Sort (cost=38,879.07..38,967.46 rows=35,357 width=32) (actual time=7.465..7.997 rows=6,051 loops=1)

  • Sort Key: (time_bucket('00:05:00'::interval, _hyper_1_1_chunk.position_ts)), _hyper_1_1_chunk.position_ts
  • Sort Method: quicksort Memory: 665kB
5. 1.530 5.294 ↑ 5.8 6,051 1

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

6. 0.727 3.764 ↑ 5.8 6,051 1

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

7. 0.143 0.143 ↑ 1.9 367 1

Index Scan using _hyper_1_1_chunk_position_mean_id_idx on _hyper_1_1_chunk (cost=0.43..717.92 rows=714 width=24) (actual time=0.024..0.143 rows=367 loops=1)

  • Index Cond: (mean_id = 31592)
8. 0.092 0.092 ↑ 2.8 252 1

Index Scan using _hyper_1_2_chunk_position_mean_id_idx on _hyper_1_2_chunk (cost=0.43..701.60 rows=697 width=24) (actual time=0.014..0.092 rows=252 loops=1)

  • Index Cond: (mean_id = 31592)
9. 0.171 0.171 ↑ 1.2 475 1

Index Scan using _hyper_1_3_chunk_position_mean_id_idx on _hyper_1_3_chunk (cost=0.43..563.21 rows=560 width=24) (actual time=0.018..0.171 rows=475 loops=1)

  • Index Cond: (mean_id = 31592)
10. 0.017 0.017 ↑ 23.9 25 1

Index Scan using _hyper_1_4_chunk_position_mean_id_idx on _hyper_1_4_chunk (cost=0.43..600.80 rows=597 width=24) (actual time=0.010..0.017 rows=25 loops=1)

  • Index Cond: (mean_id = 31592)
11. 0.066 0.066 ↑ 4.0 185 1

Index Scan using _hyper_1_5_chunk_position_mean_id_idx on _hyper_1_5_chunk (cost=0.43..752.38 rows=747 width=24) (actual time=0.013..0.066 rows=185 loops=1)

  • Index Cond: (mean_id = 31592)
12. 0.102 0.102 ↑ 2.0 315 1

Index Scan using _hyper_1_6_chunk_position_mean_id_idx on _hyper_1_6_chunk (cost=0.43..637.36 rows=633 width=24) (actual time=0.011..0.102 rows=315 loops=1)

  • Index Cond: (mean_id = 31592)
13. 0.377 0.377 ↓ 1.7 1,160 1

Index Scan using _hyper_1_7_chunk_position_mean_id_idx on _hyper_1_7_chunk (cost=0.43..700.71 rows=696 width=24) (actual time=0.014..0.377 rows=1,160 loops=1)

  • Index Cond: (mean_id = 31592)
14. 0.142 0.142 ↑ 1.6 428 1

Index Scan using _hyper_1_8_chunk_position_mean_id_idx on _hyper_1_8_chunk (cost=0.43..697.56 rows=693 width=24) (actual time=0.018..0.142 rows=428 loops=1)

  • Index Cond: (mean_id = 31592)
15. 0.083 0.083 ↑ 2.8 214 1

Index Scan using _hyper_1_9_chunk_position_mean_id_idx on _hyper_1_9_chunk (cost=0.43..609.91 rows=606 width=24) (actual time=0.021..0.083 rows=214 loops=1)

  • Index Cond: (mean_id = 31592)
16. 0.217 0.217 ↓ 1.2 712 1

Index Scan using _hyper_1_10_chunk_position_mean_id_idx on _hyper_1_10_chunk (cost=0.43..573.81 rows=571 width=24) (actual time=0.011..0.217 rows=712 loops=1)

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

Index Scan using _hyper_1_11_chunk_position_mean_id_idx on _hyper_1_11_chunk (cost=0.43..721.62 rows=717 width=24) (actual time=0.009..0.009 rows=0 loops=1)

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

Index Scan using _hyper_1_12_chunk_position_mean_id_idx on _hyper_1_12_chunk (cost=0.43..650.51 rows=646 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_13_chunk_position_mean_id_idx on _hyper_1_13_chunk (cost=0.43..744.88 rows=742 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_14_chunk_position_mean_id_idx on _hyper_1_14_chunk (cost=0.43..701.56 rows=697 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_15_chunk_position_mean_id_idx on _hyper_1_15_chunk (cost=0.43..724.72 rows=721 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_16_chunk_position_mean_id_idx on _hyper_1_16_chunk (cost=0.43..671.02 rows=667 width=24) (actual time=0.006..0.006 rows=0 loops=1)

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

Index Scan using _hyper_1_17_chunk_position_mean_id_idx on _hyper_1_17_chunk (cost=0.43..721.93 rows=718 width=24) (actual time=0.007..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_18_chunk_position_mean_id_idx on _hyper_1_18_chunk (cost=0.43..690.28 rows=686 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_19_chunk_position_mean_id_idx on _hyper_1_19_chunk (cost=0.43..712.39 rows=707 width=24) (actual time=0.006..0.006 rows=0 loops=1)

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

Index Scan using _hyper_1_23_chunk_position_mean_id_idx on _hyper_1_23_chunk (cost=0.43..704.66 rows=700 width=24) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
27. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_24_chunk_position_mean_id_idx on _hyper_1_24_chunk (cost=0.43..732.45 rows=729 width=24) (actual time=0.006..0.006 rows=0 loops=1)

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

Index Scan using _hyper_1_25_chunk_position_mean_id_idx on _hyper_1_25_chunk (cost=0.43..707.75 rows=704 width=24) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
29. 0.244 0.244 ↓ 1.0 704 1

Index Scan using _hyper_1_26_chunk_position_mean_id_idx on _hyper_1_26_chunk (cost=0.43..702.80 rows=700 width=24) (actual time=0.010..0.244 rows=704 loops=1)

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

Index Scan using _hyper_1_27_chunk_position_mean_id_idx on _hyper_1_27_chunk (cost=0.43..602.50 rows=599 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_28_chunk_position_mean_id_idx on _hyper_1_28_chunk (cost=0.43..548.97 rows=546 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_29_chunk_position_mean_id_idx on _hyper_1_29_chunk (cost=0.43..652.72 rows=648 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_30_chunk_position_mean_id_idx on _hyper_1_30_chunk (cost=0.43..644.62 rows=640 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_32_chunk_position_mean_id_idx on _hyper_1_32_chunk (cost=0.43..680.26 rows=676 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_33_chunk_position_mean_id_idx on _hyper_1_33_chunk (cost=0.43..692.40 rows=688 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_35_chunk_position_mean_id_idx on _hyper_1_35_chunk (cost=0.43..625.29 rows=621 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_36_chunk_position_mean_id_idx on _hyper_1_36_chunk (cost=0.43..624.26 rows=619 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_37_chunk_position_mean_id_idx on _hyper_1_37_chunk (cost=0.43..661.96 rows=657 width=24) (actual time=0.009..0.009 rows=0 loops=1)

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

Index Scan using _hyper_1_38_chunk_position_mean_id_idx on _hyper_1_38_chunk (cost=0.43..635.90 rows=631 width=24) (actual time=0.014..0.014 rows=0 loops=1)

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

Index Scan using _hyper_1_39_chunk_position_mean_id_idx on _hyper_1_39_chunk (cost=0.43..649.69 rows=644 width=24) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
41. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_40_chunk_position_mean_id_idx on _hyper_1_40_chunk (cost=0.43..627.22 rows=622 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
42. 0.011 0.011 ↓ 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.011 rows=0 loops=1)

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

Index Scan using _hyper_1_42_chunk_position_mean_id_idx on _hyper_1_42_chunk (cost=0.43..653.77 rows=648 width=24) (actual time=0.007..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_44_chunk_position_mean_id_idx on _hyper_1_44_chunk (cost=0.43..655.80 rows=650 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
45. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_45_chunk_position_mean_id_idx on _hyper_1_45_chunk (cost=0.43..665.93 rows=660 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_46_chunk_position_mean_id_idx on _hyper_1_46_chunk (cost=0.43..687.35 rows=681 width=24) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
47. 0.634 0.634 ↓ 1.1 686 1

Index Scan using _hyper_1_47_chunk_position_mean_id_idx on _hyper_1_47_chunk (cost=0.43..609.64 rows=609 width=24) (actual time=0.012..0.634 rows=686 loops=1)

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

Index Scan using _hyper_1_48_chunk_position_mean_id_idx on _hyper_1_48_chunk (cost=0.43..598.62 rows=593 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_49_chunk_position_mean_id_idx on _hyper_1_49_chunk (cost=0.43..699.44 rows=692 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_174_chunk_position_mean_id_idx on _hyper_1_174_chunk (cost=0.43..689.07 rows=681 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_178_chunk_position_mean_id_idx on _hyper_1_178_chunk (cost=0.43..720.63 rows=714 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_182_chunk_position_mean_id_idx on _hyper_1_182_chunk (cost=0.43..678.12 rows=670 width=24) (actual time=0.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_187_chunk_position_mean_id_idx on _hyper_1_187_chunk (cost=0.43..698.37 rows=691 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
54. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
55. 0.008 0.008 ↓ 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.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_202_chunk_position_mean_id_idx on _hyper_1_202_chunk (cost=0.43..679.88 rows=673 width=24) (actual time=0.008..0.008 rows=0 loops=1)

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

Index Scan using _hyper_1_207_chunk_position_mean_id_idx on _hyper_1_207_chunk (cost=0.43..757.51 rows=751 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
58. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_213_chunk_position_mean_id_idx on _hyper_1_213_chunk (cost=0.43..788.05 rows=780 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
59. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_248_chunk_position_mean_id_idx on _hyper_1_248_chunk (cost=0.43..775.59 rows=767 width=24) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
60. 0.426 0.426 ↑ 1.4 528 1

Index Scan using _hyper_1_270_chunk_position_mean_id_idx on _hyper_1_270_chunk (cost=0.43..759.37 rows=751 width=24) (actual time=0.015..0.426 rows=528 loops=1)

  • Index Cond: (mean_id = 31592)
Planning time : 3.170 ms
Execution time : 17.989 ms