explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hfcc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.072 ↓ 0.0 0 1

Limit (cost=0.00..10.87 rows=1 width=61) (actual time=0.072..0.072 rows=0 loops=1)

2. 0.001 0.072 ↓ 0.0 0 1

Append (cost=0.00..21.74 rows=2 width=61) (actual time=0.072..0.072 rows=0 loops=1)

3. 0.037 0.037 ↓ 0.0 0 1

Seq Scan on video (cost=0.00..15.27 rows=1 width=72) (actual time=0.037..0.037 rows=0 loops=1)

  • Filter: ((inicio <= '2020-07-06 12:00:00+00'::timestamp with time zone) AND (fim >= '2020-07-06 12:00:00+00'::timestamp with time zone) AND (inicio >= '2020-07-06 00:00:00+00'::timestamp with time zone) AND (inicio <= '2020-07-07 00:00:00+00'::timestamp with time zone) AND (veiculo_id = 10,337))
  • Rows Removed by Filter: 101
4. 0.034 0.034 ↓ 0.0 0 1

Index Scan using idx_2020_07_video_veiculo_inicio on video video_1 (cost=0.42..6.47 rows=1 width=50) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: ((veiculo_id = 10,337) AND (inicio <= '2020-07-06 12:00:00+00'::timestamp with time zone) AND (inicio >= '2020-07-06 00:00:00+00'::timestamp with time zone) AND (inicio <= '2020-07-07 00:00:00+00'::timestamp with time zone))
  • Filter: (fim >= '2020-07-06 12:00:00+00'::timestamp with time zone)