explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5RHi : old todos videos

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

Limit (cost=277.90..277.93 rows=10 width=105) (actual time=0.281..0.281 rows=0 loops=1)

2. 0.025 0.281 ↓ 0.0 0 1

Sort (cost=277.90..277.96 rows=23 width=105) (actual time=0.280..0.281 rows=0 loops=1)

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

Append (cost=0.00..277.40 rows=23 width=105) (actual time=0.256..0.256 rows=0 loops=1)

4. 0.005 0.005 ↓ 0.0 0 1

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

  • Filter: ((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.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
6. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
7. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
8. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
9. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
10. 0.008 0.008 ↓ 0.0 0 1

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

  • Filter: ((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[])))
  • Rows Removed by Filter: 1
11. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
12. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
13. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
14. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
15. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
16. 0.002 0.002 ↓ 0.0 0 1

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

  • Filter: ((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[])))
17. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
18. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((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[])))
19. 0.042 0.042 ↓ 0.0 0 1

Seq Scan on video video_15 (cost=0.00..9.47 rows=1 width=86) (actual time=0.042..0.042 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 141
20. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on video video_16 (cost=0.00..5.28 rows=1 width=87) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 73
21. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on video_fallback (cost=0.00..14.73 rows=1 width=112) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 2
22. 0.064 0.064 ↓ 0.0 0 1

Seq Scan on video video_17 (cost=0.00..9.97 rows=1 width=86) (actual time=0.064..0.064 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 170
23. 0.023 0.023 ↓ 0.0 0 1

Seq Scan on video video_18 (cost=0.00..4.29 rows=1 width=90) (actual time=0.023..0.023 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 49
24. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on video video_19 (cost=0.00..5.75 rows=1 width=83) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 75
25. 0.029 0.029 ↓ 0.0 0 1

Seq Scan on video video_20 (cost=0.00..6.93 rows=1 width=77) (actual time=0.029..0.029 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 117
26. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on video video_21 (cost=0.00..14.73 rows=1 width=112) (actual time=0.017..0.018 rows=0 loops=1)

  • Filter: ((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[])))
  • Rows Removed by Filter: 60
Planning time : 2.224 ms
Execution time : 0.434 ms