explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bv60 : brand new2

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.143 ↓ 5.0 25 1

Append (cost=0.00..101.12 rows=5 width=704) (actual time=0.023..0.143 rows=25 loops=1)

2. 0.002 0.002 ↓ 0.0 0 1

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

  • Filter: ((inicio >= '2019-10-31 00:00:00-03'::timestamp with time zone) AND (inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone))
3. 0.116 0.116 ↓ 24.0 24 1

Index Scan using idx_2019_10_video_veiculo_inicio on video video_1 (cost=0.28..67.79 rows=1 width=804) (actual time=0.020..0.116 rows=24 loops=1)

  • Index Cond: ((inicio >= '2019-10-31 00:00:00-03'::timestamp with time zone) AND (inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone))
4. 0.006 0.022 ↑ 3.0 1 1

Bitmap Heap Scan on video video_2 (cost=23.75..33.30 rows=3 width=823) (actual time=0.021..0.022 rows=1 loops=1)

  • Recheck Cond: ((inicio >= '2019-10-31 00:00:00-03'::timestamp with time zone) AND (inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone))
  • Heap Blocks: exact=1
5. 0.016 0.016 ↑ 3.0 1 1

Bitmap Index Scan on idx_2019_11_video_veiculo_inicio (cost=0.00..23.75 rows=3 width=0) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((inicio >= '2019-10-31 00:00:00-03'::timestamp with time zone) AND (inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone))
Planning time : 1.556 ms
Execution time : 0.183 ms