explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AHg1 : current

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 24.445 ↑ 2.1 25 1

Append (cost=0.00..1,472.14 rows=52 width=450) (actual time=21.862..24.445 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-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
3. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on video video_1 (cost=0.00..14.05 rows=30 width=248) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
4. 0.095 0.095 ↓ 0.0 0 1

Seq Scan on video video_2 (cost=0.00..20.31 rows=1 width=887) (actual time=0.095..0.095 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 154
5. 0.109 0.109 ↓ 0.0 0 1

Seq Scan on video video_3 (cost=0.00..31.81 rows=1 width=903) (actual time=0.109..0.109 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 254
6. 2.104 2.104 ↓ 0.0 0 1

Seq Scan on video video_4 (cost=0.00..63.80 rows=1 width=878) (actual time=2.104..2.104 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 520
7. 3.849 3.849 ↓ 0.0 0 1

Seq Scan on video video_5 (cost=0.00..114.56 rows=1 width=884) (actual time=3.849..3.849 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 904
8. 1.741 1.741 ↓ 0.0 0 1

Seq Scan on video video_6 (cost=0.00..125.26 rows=1 width=776) (actual time=1.741..1.741 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 1084
9. 0.724 0.724 ↓ 0.0 0 1

Seq Scan on video video_7 (cost=0.00..30.47 rows=1 width=755) (actual time=0.724..0.724 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 298
10. 0.123 0.123 ↓ 0.0 0 1

Seq Scan on video video_8 (cost=0.00..23.05 rows=1 width=759) (actual time=0.123..0.123 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 203
11. 0.339 0.339 ↓ 0.0 0 1

Seq Scan on video video_9 (cost=0.00..16.41 rows=1 width=700) (actual time=0.339..0.339 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 162
12. 0.037 0.037 ↓ 0.0 0 1

Seq Scan on video video_10 (cost=0.00..7.35 rows=1 width=588) (actual time=0.037..0.037 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 90
13. 0.425 0.425 ↓ 0.0 0 1

Seq Scan on video video_11 (cost=0.00..25.56 rows=1 width=613) (actual time=0.424..0.425 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 304
14. 0.372 0.372 ↓ 0.0 0 1

Seq Scan on video video_12 (cost=0.00..14.99 rows=1 width=763) (actual time=0.372..0.372 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 133
15. 0.066 0.066 ↓ 0.0 0 1

Seq Scan on video video_13 (cost=0.00..14.83 rows=1 width=835) (actual time=0.066..0.066 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 122
16. 0.118 0.118 ↓ 0.0 0 1

Seq Scan on video video_14 (cost=0.00..27.98 rows=1 width=746) (actual time=0.118..0.118 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 265
17. 0.289 0.289 ↓ 0.0 0 1

Seq Scan on video video_15 (cost=0.00..52.48 rows=1 width=673) (actual time=0.289..0.289 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 499
18. 10.539 10.539 ↓ 0.0 0 1

Seq Scan on video video_16 (cost=0.00..330.58 rows=1 width=502) (actual time=10.539..10.539 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 4572
19. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on video_fallback (cost=0.00..1.07 rows=1 width=248) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 6
20. 0.775 0.775 ↓ 0.0 0 1

Seq Scan on video video_17 (cost=0.00..179.63 rows=1 width=905) (actual time=0.774..0.775 rows=0 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 1243
21. 2.684 2.684 ↓ 24.0 24 1

Seq Scan on video video_18 (cost=0.00..345.25 rows=1 width=804) (actual time=0.133..2.684 rows=24 loops=1)

  • Filter: ((inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone) AND (fim >= '2019-10-31 00:00:00-03'::timestamp with time zone))
  • Rows Removed by Filter: 906
22. 0.006 0.027 ↑ 3.0 1 1

Bitmap Heap Scan on video video_19 (cost=22.88..32.43 rows=3 width=823) (actual time=0.027..0.027 rows=1 loops=1)

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

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

  • Index Cond: (inicio <= '2019-11-01 10:04:00-03'::timestamp with time zone)
Planning time : 3.513 ms
Execution time : 25.195 ms