explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C4IT

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.472 ↑ 30.0 1 1

Append (cost=0.14..130.22 rows=30 width=696) (actual time=0.463..0.472 rows=1 loops=1)

2. 0.016 0.016 ↓ 0.0 0 1

Index Scan using pk_video on video (cost=0.14..4.18 rows=1 width=328) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
3. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_2018_05_video on video video_1 (cost=0.14..4.18 rows=1 width=328) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
4. 0.016 0.016 ↓ 0.0 0 1

Index Scan using pk_2018_06_video on video video_2 (cost=0.28..4.31 rows=1 width=328) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
5. 0.019 0.019 ↓ 0.0 0 1

Index Scan using pk_2018_07_video on video video_3 (cost=0.29..4.32 rows=1 width=328) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
6. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on video_fallback (cost=0.00..2.41 rows=1 width=328) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: ((id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid) AND (inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
  • Rows Removed by Filter: 15
7. 0.022 0.022 ↓ 0.0 0 1

Index Scan using pk_2018_08_video on video video_4 (cost=0.29..4.32 rows=1 width=328) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
8. 0.008 0.008 ↓ 0.0 0 1

Index Scan using pk_2018_09_video on video video_5 (cost=0.29..4.32 rows=1 width=911) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
9. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pk_2018_10_video on video video_6 (cost=0.42..4.45 rows=1 width=851) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
10. 0.014 0.014 ↓ 0.0 0 1

Index Scan using pk_2018_11_video on video video_7 (cost=0.42..4.45 rows=1 width=771) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
11. 0.012 0.012 ↓ 0.0 0 1

Index Scan using pk_2018_12_video on video video_8 (cost=0.42..4.45 rows=1 width=749) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
12. 0.017 0.017 ↓ 0.0 0 1

Index Scan using pk_2019_01_video on video video_9 (cost=0.42..4.45 rows=1 width=761) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
13. 0.011 0.011 ↓ 0.0 0 1

Index Scan using pk_2019_02_video on video video_10 (cost=0.42..4.45 rows=1 width=757) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
14. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pk_2019_03_video on video video_11 (cost=0.42..4.45 rows=1 width=760) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
15. 0.014 0.014 ↓ 0.0 0 1

Index Scan using pk_2019_04_video on video video_12 (cost=0.42..4.45 rows=1 width=802) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
16. 0.012 0.012 ↓ 0.0 0 1

Index Scan using pk_2019_05_video on video video_13 (cost=0.42..4.45 rows=1 width=814) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
17. 0.019 0.019 ↓ 0.0 0 1

Index Scan using pk_2019_06_video on video video_14 (cost=0.42..4.45 rows=1 width=813) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
18. 0.016 0.016 ↓ 0.0 0 1

Index Scan using pk_2019_07_video on video video_15 (cost=0.42..4.46 rows=1 width=813) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
19. 0.016 0.016 ↓ 0.0 0 1

Index Scan using pk_2019_08_video on video video_16 (cost=0.42..4.46 rows=1 width=829) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
20. 0.022 0.022 ↓ 0.0 0 1

Index Scan using pk_2019_09_video on video video_17 (cost=0.42..4.46 rows=1 width=803) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
21. 0.014 0.014 ↓ 0.0 0 1

Index Scan using pk_2019_10_video on video video_18 (cost=0.42..4.46 rows=1 width=796) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
22. 0.022 0.022 ↓ 0.0 0 1

Index Scan using pk_2019_11_video on video video_19 (cost=0.42..4.46 rows=1 width=801) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
23. 0.018 0.018 ↓ 0.0 0 1

Index Scan using pk_2019_12_video on video video_20 (cost=0.42..4.46 rows=1 width=791) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
24. 0.020 0.020 ↓ 0.0 0 1

Index Scan using pk_2020_01_video on video video_21 (cost=0.42..4.46 rows=1 width=796) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
25. 0.014 0.014 ↓ 0.0 0 1

Index Scan using pk_2020_02_video on video video_22 (cost=0.42..4.46 rows=1 width=797) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
26. 0.010 0.010 ↓ 0.0 0 1

Index Scan using pk_2020_03_video on video video_23 (cost=0.42..4.46 rows=1 width=802) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
27. 0.023 0.023 ↓ 0.0 0 1

Index Scan using pk_2020_04_video on video video_24 (cost=0.43..4.47 rows=1 width=855) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
28. 0.017 0.017 ↓ 0.0 0 1

Index Scan using pk_2020_05_video on video video_25 (cost=0.43..4.46 rows=1 width=829) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
29. 0.014 0.014 ↓ 0.0 0 1

Index Scan using pk_2020_06_video on video video_26 (cost=0.43..4.46 rows=1 width=829) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
30. 0.042 0.042 ↑ 1.0 1 1

Index Scan using pk_2020_07_video on video video_27 (cost=0.41..4.45 rows=1 width=818) (actual time=0.035..0.042 rows=1 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
31. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_2020_08_video on video video_28 (cost=0.14..4.18 rows=1 width=328) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (id = '2b9539e3-df50-491f-b981-a897ae2a037e'::uuid)
  • Filter: ((inicio >= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) - '1 day'::interval)) AND (inicio <= (to_timestamp('20200630232726'::text, 'YYYYMMDDhh24miss'::text) + '1 day'::interval)))
Planning time : 10.484 ms
Execution time : 0.682 ms