explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ZAK

Settings
# exclusive inclusive rows x rows loops node
1. 0.474 17.160 ↓ 10.2 1,805 1

Sort (cost=40,301.11..40,301.56 rows=177 width=40) (actual time=17.038..17.160 rows=1,805 loops=1)

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

Subquery Scan on q (cost=38,880.18..40,294.50 rows=177 width=40) (actual time=7.191..16.686 rows=1,805 loops=1)

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

WindowAgg (cost=38,880.18..39,852.53 rows=35,358 width=56) (actual time=7.189..15.802 rows=6,051 loops=1)

4. 2.448 7.673 ↑ 5.8 6,051 1

Sort (cost=38,880.18..38,968.58 rows=35,358 width=32) (actual time=7.169..7.673 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.504 5.225 ↑ 5.8 6,051 1

Result (cost=0.43..36,208.93 rows=35,358 width=32) (actual time=0.027..5.225 rows=6,051 loops=1)

6. 0.733 3.721 ↑ 5.8 6,051 1

Append (cost=0.43..35,766.96 rows=35,358 width=24) (actual time=0.026..3.721 rows=6,051 loops=1)

7. 0.130 0.130 ↑ 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.025..0.130 rows=367 loops=1)

  • Index Cond: (mean_id = 31592)
8. 0.086 0.086 ↑ 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.009..0.086 rows=252 loops=1)

  • Index Cond: (mean_id = 31592)
9. 0.165 0.165 ↑ 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.017..0.165 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.064 0.064 ↑ 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.012..0.064 rows=185 loops=1)

  • Index Cond: (mean_id = 31592)
12. 0.118 0.118 ↑ 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.118 rows=315 loops=1)

  • Index Cond: (mean_id = 31592)
13. 0.405 0.405 ↓ 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.021..0.405 rows=1,160 loops=1)

  • Index Cond: (mean_id = 31592)
14. 0.146 0.146 ↑ 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.146 rows=428 loops=1)

  • Index Cond: (mean_id = 31592)
15. 0.076 0.076 ↑ 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.013..0.076 rows=214 loops=1)

  • Index Cond: (mean_id = 31592)
16. 0.224 0.224 ↓ 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.224 rows=712 loops=1)

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

  • Index Cond: (mean_id = 31592)
18. 0.009 0.009 ↓ 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.009 rows=0 loops=1)

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

  • Index Cond: (mean_id = 31592)
26. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

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

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

  • Index Cond: (mean_id = 31592)
29. 0.234 0.234 ↓ 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.016..0.234 rows=704 loops=1)

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

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

  • Index Cond: (mean_id = 31592)
39. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
40. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
41. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

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

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

  • Filter: (mean_id = 31592)
  • Rows Removed by Filter: 1
43. 0.007 0.007 ↓ 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.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
44. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
45. 0.007 0.007 ↓ 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.007..0.007 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.633 0.633 ↓ 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.011..0.633 rows=686 loops=1)

  • Index Cond: (mean_id = 31592)
48. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
49. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

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

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

  • Index Cond: (mean_id = 31592)
56. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
57. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
58. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (mean_id = 31592)
59. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

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

Index Scan using _hyper_1_270_chunk_position_mean_id_idx on _hyper_1_270_chunk (cost=0.43..760.39 rows=752 width=24) (actual time=0.016..0.386 rows=528 loops=1)

  • Index Cond: (mean_id = 31592)
Planning time : 3.207 ms
Execution time : 17.586 ms