explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5oQ : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.341 ↑ 27.0 1 1

Result (cost=0.00..190.99 rows=27 width=48) (actual time=0.205..0.341 rows=1 loops=1)

2. 0.010 0.338 ↑ 27.0 1 1

Append (cost=0.00..190.59 rows=27 width=40) (actual time=0.202..0.338 rows=1 loops=1)

3. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on uzgps_track_point t (cost=0.00..0.00 rows=1 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (id_track_point = 2044028317)
4. 0.020 0.020 ↓ 0.0 0 1

Index Scan using uzgps_track_point_0000m00_pkey on uzgps_track_point_0000m00 t_1 (cost=0.42..8.44 rows=1 width=40) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
5. 0.013 0.013 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m01_pkey on uzgps_track_point_2018m01 t_2 (cost=0.56..8.58 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
6. 0.012 0.012 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m02_pkey on uzgps_track_point_2018m02 t_3 (cost=0.56..8.58 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
7. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m03_pkey on uzgps_track_point_2018m03 t_4 (cost=0.57..8.59 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
8. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m04_pkey on uzgps_track_point_2018m04 t_5 (cost=0.56..8.58 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
9. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m05_pkey on uzgps_track_point_2018m05 t_6 (cost=0.56..8.58 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
10. 0.012 0.012 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m06_pkey on uzgps_track_point_2018m06 t_7 (cost=0.57..8.59 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
11. 0.013 0.013 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m07_pkey on uzgps_track_point_2018m07 t_8 (cost=0.57..8.59 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
12. 0.013 0.013 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m08_pkey on uzgps_track_point_2018m08 t_9 (cost=0.57..8.59 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
13. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m09_pkey on uzgps_track_point_2018m09 t_10 (cost=0.57..8.59 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
14. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m10_pkey on uzgps_track_point_2018m10 t_11 (cost=0.57..8.59 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
15. 0.013 0.013 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m11_pkey on uzgps_track_point_2018m11 t_12 (cost=0.57..8.59 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
16. 0.013 0.013 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m12_pkey on uzgps_track_point_2018m12 t_13 (cost=0.57..8.59 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
17. 0.008 0.008 ↓ 0.0 0 1

Index Scan using uzgps_track_point_9999m99_pkey on uzgps_track_point_9999m99 t_14 (cost=0.29..8.31 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
18. 0.015 0.015 ↑ 1.0 1 1

Index Scan using uzgps_track_point_2019m01_pkey on uzgps_track_point_2019m01 t_15 (cost=0.44..8.46 rows=1 width=40) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (id_track_point = 2044028317)
19. 0.006 0.006 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m02_pkey on uzgps_track_point_2019m02 t_16 (cost=0.28..8.29 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
20. 0.046 0.046 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m03 t_17 (cost=0.00..8.05 rows=1 width=40) (actual time=0.046..0.046 rows=0 loops=1)

  • Filter: (id_track_point = 2044028317)
  • Rows Removed by Filter: 164
21. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m04 t_18 (cost=0.00..3.46 rows=1 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (id_track_point = 2044028317)
  • Rows Removed by Filter: 37
22. 0.002 0.002 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m05_pkey on uzgps_track_point_2019m05 t_19 (cost=0.14..8.16 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
23. 0.002 0.002 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m06_pkey on uzgps_track_point_2019m06 t_20 (cost=0.14..8.16 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
24. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m07 t_21 (cost=0.00..1.18 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (id_track_point = 2044028317)
  • Rows Removed by Filter: 14
25. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m08 t_22 (cost=0.00..2.39 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (id_track_point = 2044028317)
  • Rows Removed by Filter: 31
26. 0.006 0.006 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m09_pkey on uzgps_track_point_2019m09 t_23 (cost=0.29..8.30 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
27. 0.005 0.005 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m10_pkey on uzgps_track_point_2019m10 t_24 (cost=0.28..8.29 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
28. 0.028 0.028 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m11 t_25 (cost=0.00..5.06 rows=1 width=40) (actual time=0.028..0.028 rows=0 loops=1)

  • Filter: (id_track_point = 2044028317)
  • Rows Removed by Filter: 85
29. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m12 t_26 (cost=0.00..1.02 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (id_track_point = 2044028317)
  • Rows Removed by Filter: 2