explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pY7p : brand new

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.150 ↑ 12.5 2 1

Limit (cost=0.00..176.00 rows=25 width=708) (actual time=0.137..0.150 rows=2 loops=1)

2. 0.001 0.148 ↑ 12.5 2 1

Append (cost=0.00..176.00 rows=25 width=708) (actual time=0.136..0.148 rows=2 loops=1)

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on video (cost=0.00..0.00 rows=1 width=272) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone) AND (fim >= '2020-01-06 05:23:00'::timestamp without time zone) AND (veiculo_id = 90539))
4. 0.011 0.011 ↓ 0.0 0 1

Index Scan using idx_2018_05_video_veiculo_inicio on video video_1 (cost=0.15..8.18 rows=1 width=272) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
5. 0.010 0.010 ↓ 0.0 0 1

Index Scan using idx_2018_06_video_veiculo_inicio on video video_2 (cost=0.14..8.17 rows=1 width=911) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
6. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_2018_07_video_veiculo_inicio on video video_3 (cost=0.14..8.17 rows=1 width=927) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
7. 0.021 0.021 ↓ 0.0 0 1

Index Scan using idx_2018_08_video_veiculo_inicio on video video_4 (cost=0.28..8.30 rows=1 width=902) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
8. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_2018_09_video_veiculo_inicio on video video_5 (cost=0.28..6.44 rows=1 width=908) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
9. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_2018_10_video_veiculo_inicio on video video_6 (cost=0.28..6.78 rows=1 width=800) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
10. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_2018_11_video_veiculo_inicio on video video_7 (cost=0.27..8.30 rows=1 width=779) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
11. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_2018_12_video_veiculo_inicio on video video_8 (cost=0.14..7.23 rows=1 width=783) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
12. 0.005 0.005 ↓ 0.0 0 1

Index Scan using idx_2019_01_video_veiculo_inicio on video video_9 (cost=0.14..8.17 rows=1 width=721) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
13. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_2019_02_video_veiculo_inicio on video video_10 (cost=0.14..6.89 rows=1 width=612) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
14. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_2019_03_video_veiculo_inicio on video video_11 (cost=0.27..8.30 rows=1 width=623) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
15. 0.005 0.005 ↓ 0.0 0 1

Index Scan using idx_2019_04_video_veiculo_inicio on video video_12 (cost=0.14..8.17 rows=1 width=787) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
16. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_2019_05_video_veiculo_inicio on video video_13 (cost=0.14..6.15 rows=1 width=859) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
17. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_2019_06_video_veiculo_inicio on video video_14 (cost=0.27..8.30 rows=1 width=770) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
18. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_2019_07_video_veiculo_inicio on video video_15 (cost=0.27..8.30 rows=1 width=702) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
19. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_2019_08_video_veiculo_inicio on video video_16 (cost=0.28..8.31 rows=1 width=527) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
20. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_2019_09_video_veiculo_inicio on video video_17 (cost=0.28..6.91 rows=1 width=928) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
21. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_2019_10_video_veiculo_inicio on video video_18 (cost=0.28..8.18 rows=1 width=817) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
22. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx_2019_11_video_veiculo_inicio on video video_19 (cost=0.27..7.74 rows=1 width=846) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
23. 0.005 0.005 ↓ 0.0 0 1

Index Scan using idx_2019_12_video_veiculo_inicio on video video_20 (cost=0.28..8.30 rows=1 width=731) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
24. 0.010 0.020 ↑ 1.0 2 1

Bitmap Heap Scan on video video_21 (cost=4.31..11.40 rows=2 width=841) (actual time=0.017..0.020 rows=2 loops=1)

  • Recheck Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=3
25. 0.010 0.010 ↓ 2.0 4 1

Bitmap Index Scan on idx_2020_01_video_veiculo_inicio (cost=0.00..4.31 rows=2 width=0) (actual time=0.010..0.010 rows=4 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
26. 0.003 0.003 ↓ 0.0 0 1

Index Scan using idx_2020_02_video_veiculo_inicio on video video_22 (cost=0.15..8.18 rows=1 width=272) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 90539) AND (inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone))
  • Filter: (fim >= '2020-01-06 05:23:00'::timestamp without time zone)
27. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on video_fallback (cost=0.00..1.14 rows=1 width=272) (actual time=0.005..0.006 rows=0 loops=1)

  • Filter: ((inicio >= '2020-01-04 05:23:00'::timestamp without time zone) AND (inicio <= '2020-01-08 05:24:00'::timestamp without time zone) AND (inicio <= '2020-01-06 05:24:00'::timestamp without time zone) AND (fim >= '2020-01-06 05:23:00'::timestamp without time zone) AND (veiculo_id = 90539))
  • Rows Removed by Filter: 6
Planning time : 3.484 ms
Execution time : 0.434 ms