explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n2ucB : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.263 ↑ 27.0 1 1

Result (cost=0.00..191.58 rows=27 width=48) (actual time=0.180..0.263 rows=1 loops=1)

2. 0.003 0.262 ↑ 27.0 1 1

Append (cost=0.00..191.17 rows=27 width=40) (actual time=0.179..0.262 rows=1 loops=1)

3. 0.002 0.002 ↓ 0.0 0 1

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

  • Filter: ((id_track_point = 2044028317) AND (tp_status = 'A'::bpchar))
4. 0.014 0.014 ↓ 0.0 0 1

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

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
5. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
6. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
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)
  • Filter: (tp_status = 'A'::bpchar)
8. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
9. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
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)
  • Filter: (tp_status = 'A'::bpchar)
11. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
12. 0.012 0.012 ↓ 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.012..0.012 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
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)
  • Filter: (tp_status = 'A'::bpchar)
14. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
15. 0.016 0.016 ↓ 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.016..0.016 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
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)
  • Filter: (tp_status = 'A'::bpchar)
17. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
18. 0.017 0.017 ↑ 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.016..0.017 rows=1 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
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.30 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
20. 0.003 0.003 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m03_pkey on uzgps_track_point_2019m03 t_17 (cost=0.14..8.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
21. 0.015 0.015 ↓ 0.0 0 1

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

  • Filter: ((id_track_point = 2044028317) AND (tp_status = 'A'::bpchar))
  • 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)
  • Filter: (tp_status = 'A'::bpchar)
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)
  • Filter: (tp_status = 'A'::bpchar)
24. 0.005 0.005 ↓ 0.0 0 1

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

  • Filter: ((id_track_point = 2044028317) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 14
25. 0.013 0.013 ↓ 0.0 0 1

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

  • Filter: ((id_track_point = 2044028317) AND (tp_status = 'A'::bpchar))
  • 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)
  • Filter: (tp_status = 'A'::bpchar)
27. 0.006 0.006 ↓ 0.0 0 1

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

  • Index Cond: (id_track_point = 2044028317)
  • Filter: (tp_status = 'A'::bpchar)
28. 0.020 0.020 ↓ 0.0 0 1

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

  • Filter: ((id_track_point = 2044028317) AND (tp_status = 'A'::bpchar))
  • 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.03 rows=1 width=40) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((id_track_point = 2044028317) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 2