explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dlGyn : NEW VIDEO TODOS 2

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

Limit (cost=15.56..15.56 rows=2 width=112) (actual time=0.074..0.074 rows=0 loops=1)

2. 0.024 0.074 ↓ 0.0 0 1

Sort (cost=15.56..15.56 rows=2 width=112) (actual time=0.074..0.074 rows=0 loops=1)

  • Sort Key: video.inicio
  • Sort Method: quicksort Memory: 25kB
3. 0.001 0.050 ↓ 0.0 0 1

Append (cost=0.00..15.55 rows=2 width=112) (actual time=0.050..0.050 rows=0 loops=1)

4. 0.003 0.003 ↓ 0.0 0 1

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

  • Filter: ((inicio >= '2020-01-29 00:00:00-03'::timestamp with time zone) AND (inicio <= '2020-02-02 00:00:00-03'::timestamp with time zone) AND (inicio <= '2020-01-31 10:17:42.962-03'::timestamp with time zone) AND (fim >= '2020-01-31 00:00:00-03'::timestamp with time zone) AND ((status)::text = ANY ('{CONCLUIDO,ASSISTIDO}'::text[])))
5. 0.046 0.046 ↓ 0.0 0 1

Index Scan using idx_2020_01_video_veiculo_inicio on video video_1 (cost=0.15..15.54 rows=1 width=112) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: ((inicio >= '2020-01-29 00:00:00-03'::timestamp with time zone) AND (inicio <= '2020-02-02 00:00:00-03'::timestamp with time zone) AND (inicio <= '2020-01-31 10:17:42.962-03'::timestamp with time zone))
  • Filter: ((fim >= '2020-01-31 00:00:00-03'::timestamp with time zone) AND ((status)::text = ANY ('{CONCLUIDO,ASSISTIDO}'::text[])))
  • Rows Removed by Filter: 10
Planning time : 6.697 ms
Execution time : 0.133 ms