explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 33PX

Settings
# exclusive inclusive rows x rows loops node
1. 132.610 2,981.156 ↑ 1.0 1,000,000 1

Limit (cost=0.42..266,894.28 rows=1,000,000 width=24) (actual time=0.071..2,981.156 rows=1,000,000 loops=1)

2. 1,626.459 2,848.546 ↑ 2.3 1,000,000 1

Result (cost=0.42..603,383.10 rows=2,260,759 width=24) (actual time=0.069..2,848.546 rows=1,000,000 loops=1)

3. 127.140 1,222.087 ↑ 2.3 1,000,000 1

Append (cost=0.42..546,864.13 rows=2,260,759 width=1,565) (actual time=0.062..1,222.087 rows=1,000,000 loops=1)

4. 79.087 79.087 ↑ 1.3 50,069 1

Index Scan using _hyper_1_14_chunk_idx_vehicle_no on _hyper_1_14_chunk (cost=0.42..14,891.30 rows=63,508 width=1,572) (actual time=0.061..79.087 rows=50,069 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
5. 0.029 0.029 ↓ 0.0 0 1

Index Scan using _hyper_1_351_chunk_idx_vehicle_no on _hyper_1_351_chunk (cost=0.42..2.65 rows=1 width=1,571) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
6. 121.195 121.195 ↑ 1.1 76,644 1

Index Scan using _hyper_1_25_chunk_idx_vehicle_no on _hyper_1_25_chunk (cost=0.42..20,568.59 rows=86,696 width=1,564) (actual time=0.050..121.195 rows=76,644 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
7. 87.995 87.995 ↑ 1.0 72,417 1

Index Scan using _hyper_1_27_chunk_idx_vehicle_no on _hyper_1_27_chunk (cost=0.42..17,149.93 rows=72,796 width=1,564) (actual time=0.066..87.995 rows=72,417 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
8. 56.390 56.390 ↑ 1.3 64,518 1

Index Scan using _hyper_1_8_chunk_idx_vehicle_no on _hyper_1_8_chunk (cost=0.42..19,847.97 rows=84,866 width=1,558) (actual time=0.045..56.390 rows=64,518 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
9. 20.340 20.340 ↑ 1.4 26,519 1

Index Scan using _hyper_1_12_chunk_idx_vehicle_no on _hyper_1_12_chunk (cost=0.42..8,786.08 rows=37,482 width=1,557) (actual time=0.047..20.340 rows=26,519 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
10. 29.583 29.583 ↑ 1.2 37,092 1

Index Scan using _hyper_1_17_chunk_idx_vehicle_no on _hyper_1_17_chunk (cost=0.42..10,892.40 rows=46,332 width=1,572) (actual time=0.069..29.583 rows=37,092 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
11. 56.302 56.302 ↑ 1.0 68,720 1

Index Scan using _hyper_1_28_chunk_idx_vehicle_no on _hyper_1_28_chunk (cost=0.42..16,283.57 rows=68,755 width=1,571) (actual time=0.045..56.302 rows=68,720 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
12. 54.619 54.619 ↑ 1.1 66,776 1

Index Scan using _hyper_1_1_chunk_idx_vehicle_no on _hyper_1_1_chunk (cost=0.42..17,800.46 rows=73,303 width=1,568) (actual time=0.047..54.619 rows=66,776 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
13. 105.050 105.050 ↑ 1.3 78,319 1

Index Scan using _hyper_1_15_chunk_idx_vehicle_no on _hyper_1_15_chunk (cost=0.42..22,893.98 rows=98,606 width=1,565) (actual time=0.062..105.050 rows=78,319 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
14. 26.854 26.854 ↑ 1.6 34,868 1

Index Scan using _hyper_1_10_chunk_idx_vehicle_no on _hyper_1_10_chunk (cost=0.42..12,804.40 rows=54,470 width=1,578) (actual time=0.059..26.854 rows=34,868 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
15. 43.916 43.916 ↑ 1.1 58,659 1

Index Scan using _hyper_1_26_chunk_idx_vehicle_no on _hyper_1_26_chunk (cost=0.42..14,611.01 rows=62,857 width=1,550) (actual time=0.046..43.916 rows=58,659 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
16. 47.105 47.105 ↑ 1.4 53,337 1

Index Scan using _hyper_1_11_chunk_idx_vehicle_no on _hyper_1_11_chunk (cost=0.42..18,182.74 rows=75,725 width=1,580) (actual time=0.052..47.105 rows=53,337 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
17. 153.903 153.903 ↑ 1.3 117,825 1

Index Scan using _hyper_1_4_chunk_idx_vehicle_no on _hyper_1_4_chunk (cost=0.42..36,663.69 rows=149,745 width=1,582) (actual time=0.046..153.903 rows=117,825 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
18. 104.139 104.139 ↑ 1.3 77,028 1

Index Scan using _hyper_1_18_chunk_idx_vehicle_no on _hyper_1_18_chunk (cost=0.42..22,832.03 rows=97,549 width=1,555) (actual time=0.062..104.139 rows=77,028 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
19. 99.200 99.200 ↓ 1.0 104,165 1

Index Scan using _hyper_1_30_chunk_idx_vehicle_no on _hyper_1_30_chunk (cost=0.42..24,730.35 rows=104,092 width=1,560) (actual time=0.036..99.200 rows=104,165 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
20. 9.240 9.240 ↑ 1.8 13,044 1

Index Scan using _hyper_1_16_chunk_idx_vehicle_no on _hyper_1_16_chunk (cost=0.42..5,416.53 rows=23,585 width=1,557) (actual time=0.051..9.240 rows=13,044 loops=1)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
21. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_6_chunk_idx_vehicle_no on _hyper_1_6_chunk (cost=0.42..27,471.74 rows=115,941 width=1,562) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
22. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_19_chunk_idx_vehicle_no on _hyper_1_19_chunk (cost=0.42..31,522.56 rows=131,904 width=1,568) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_29_chunk_idx_vehicle_no on _hyper_1_29_chunk (cost=0.42..23,899.41 rows=101,924 width=1,552) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_2_chunk_idx_vehicle_no on _hyper_1_2_chunk (cost=0.42..8,088.87 rows=34,713 width=1,555) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
25. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_21_chunk_idx_vehicle_no on _hyper_1_21_chunk (cost=0.42..3,993.99 rows=17,546 width=1,561) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_3_chunk_idx_vehicle_no on _hyper_1_3_chunk (cost=0.42..30,798.92 rows=128,929 width=1,572) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
27. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_23_chunk_idx_vehicle_no on _hyper_1_23_chunk (cost=0.42..17,805.02 rows=75,673 width=1,573) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_31_chunk_vehicle_telemetry_timestamp_idx on _hyper_1_31_chunk (cost=0.42..2.65 rows=1 width=1,543) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
  • Filter: (vehicle_no = 'B2201'::text)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_20_chunk_idx_vehicle_no on _hyper_1_20_chunk (cost=0.42..12,824.13 rows=54,946 width=1,564) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_13_chunk_idx_vehicle_no on _hyper_1_13_chunk (cost=0.42..3,360.43 rows=14,608 width=1,554) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_5_chunk_idx_vehicle_no on _hyper_1_5_chunk (cost=0.42..15,437.77 rows=65,825 width=1,534) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_22_chunk_idx_vehicle_no on _hyper_1_22_chunk (cost=0.42..11,475.98 rows=48,935 width=1,566) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_9_chunk_idx_vehicle_no on _hyper_1_9_chunk (cost=0.42..25,479.06 rows=103,508 width=1,580) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_7_chunk_idx_vehicle_no on _hyper_1_7_chunk (cost=0.42..21,221.75 rows=89,938 width=1,565) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_1_24_chunk_idx_vehicle_no on _hyper_1_24_chunk (cost=0.42..17,820.37 rows=76,000 width=1,561) (never executed)

  • Index Cond: (vehicle_no = 'B2201'::text)
  • Filter: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
Planning time : 4.441 ms
Execution time : 3,043.341 ms