explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BcJZ

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

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

2. 0.005 0.232 ↓ 0.0 0 1

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

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

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

4. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on video (cost=0.00..0.00 rows=1 width=112) (actual time=0.007..0.007 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.002 0.002 ↓ 0.0 0 1

Seq Scan on video video_4 (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[])))
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.007 0.007 ↓ 0.0 0 1

Seq Scan on video video_6 (cost=0.00..14.73 rows=1 width=112) (actual time=0.007..0.007 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.040 0.040 ↓ 0.0 0 1

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

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

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

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

Seq Scan on video video_19 (cost=0.00..5.75 rows=1 width=83) (actual time=0.020..0.020 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.018..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.115 ms
Execution time : 0.373 ms