explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ce9V : OLD VIDEO TODOS

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

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

2. 0.027 0.291 ↓ 0.0 0 1

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

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

Append (cost=0.00..277.40 rows=23 width=105) (actual time=0.264..0.264 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-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.003 0.003 ↓ 0.0 0 1

Seq Scan on video video_9 (cost=0.00..14.73 rows=1 width=112) (actual time=0.003..0.003 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.001 0.001 ↓ 0.0 0 1

Seq Scan on video video_12 (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[])))
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.045 0.045 ↓ 0.0 0 1

Seq Scan on video video_15 (cost=0.00..9.47 rows=1 width=86) (actual time=0.045..0.045 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.022 0.022 ↓ 0.0 0 1

Seq Scan on video video_16 (cost=0.00..5.28 rows=1 width=87) (actual time=0.022..0.022 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.005 0.005 ↓ 0.0 0 1

Seq Scan on video_fallback (cost=0.00..14.73 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[])))
  • Rows Removed by Filter: 2
22. 0.056 0.056 ↓ 0.0 0 1

Seq Scan on video video_17 (cost=0.00..9.97 rows=1 width=86) (actual time=0.056..0.056 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.016 0.016 ↓ 0.0 0 1

Seq Scan on video video_18 (cost=0.00..4.29 rows=1 width=90) (actual time=0.016..0.016 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.021 0.021 ↓ 0.0 0 1

Seq Scan on video video_19 (cost=0.00..5.75 rows=1 width=83) (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: 75
25. 0.049 0.049 ↓ 0.0 0 1

Seq Scan on video video_20 (cost=0.00..6.93 rows=1 width=77) (actual time=0.049..0.049 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.019 0.019 ↓ 0.0 0 1

Seq Scan on video video_21 (cost=0.00..14.73 rows=1 width=112) (actual time=0.019..0.019 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.271 ms
Execution time : 0.467 ms