explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 46kA

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.056 ↓ 0.0 0 1

Limit (cost=0.00..9.86 rows=1 width=61) (actual time=0.056..0.056 rows=0 loops=1)

2. 0.000 0.055 ↓ 0.0 0 1

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

3. 0.042 0.042 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((veiculo_id = 82,258) AND (inicio <= '2020-07-06 10:00:00+00'::timestamp with time zone) AND (inicio >= '2020-07-06 09:00:00+00'::timestamp with time zone) AND (inicio <= '2020-07-06 11:00:00+00'::timestamp with time zone))
  • Filter: (fim >= '2020-07-06 10:00:00+00'::timestamp with time zone)
Planning time : 3.028 ms
Execution time : 0.092 ms