explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rXNc : brand new

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.295 ↓ 5.0 25 1

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

2. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on video (cost=0.00..0.00 rows=1 width=248) (actual time=0.003..0.003 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.234 0.234 ↓ 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.039..0.234 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.016 0.054 ↑ 3.0 1 1

Bitmap Heap Scan on video video_2 (cost=23.75..33.30 rows=3 width=823) (actual time=0.053..0.054 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.038 0.038 ↑ 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.038..0.038 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 : 8.132 ms
Execution time : 0.383 ms