explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eE3P

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.386 ↑ 1.0 10 1

Limit (cost=26.42..38.25 rows=10 width=787) (actual time=0.370..0.386 rows=10 loops=1)

2. 0.003 0.376 ↑ 372.1 10 1

Merge Append (cost=26.42..4,430.87 rows=3,721 width=787) (actual time=0.368..0.376 rows=10 loops=1)

  • Sort Key: videos_y2005_q2.published DESC
3. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using videos_y2005_q2_published_idx on videos_y2005_q2 (cost=0.14..1.29 rows=1 width=396) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
4. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2005_q3_published_idx on videos_y2005_q3 (cost=0.28..2.45 rows=1 width=464) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
5. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using videos_y2005_q4_published_idx on videos_y2005_q4 (cost=0.28..2.49 rows=1 width=446) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
6. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2006_q1_published_idx on videos_y2006_q1 (cost=0.28..2.50 rows=1 width=525) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
7. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using videos_y2006_q2_published_idx on videos_y2006_q2 (cost=0.29..2.51 rows=1 width=530) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
8. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2006_q3_published_idx on videos_y2006_q3 (cost=0.29..2.51 rows=1 width=555) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
9. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using videos_y2006_q4_published_idx on videos_y2006_q4 (cost=0.29..2.51 rows=1 width=559) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
10. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using videos_y2007_q1_published_idx on videos_y2007_q1 (cost=0.29..2.51 rows=1 width=578) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
11. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2007_q2_published_idx on videos_y2007_q2 (cost=0.29..2.51 rows=1 width=591) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
12. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2007_q3_published_idx on videos_y2007_q3 (cost=0.29..2.51 rows=1 width=596) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
13. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2007_q4_published_idx on videos_y2007_q4 (cost=0.29..2.51 rows=1 width=596) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
14. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using videos_y2008_q1_published_idx on videos_y2008_q1 (cost=0.30..2.52 rows=1 width=604) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
15. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2008_q2_published_idx on videos_y2008_q2 (cost=0.30..2.52 rows=1 width=615) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
16. 0.014 0.014 ↓ 0.0 0 1

Index Scan Backward using videos_y2008_q3_channel_id_published_idx on videos_y2008_q3 (cost=0.42..2.64 rows=1 width=627) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
17. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2008_q4_channel_id_published_idx on videos_y2008_q4 (cost=0.42..2.64 rows=1 width=647) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
18. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2009_q1_published_idx on videos_y2009_q1 (cost=0.42..2.64 rows=1 width=666) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
19. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2009_q2_published_idx on videos_y2009_q2 (cost=0.42..2.64 rows=1 width=671) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
20. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2009_q3_published_idx on videos_y2009_q3 (cost=0.43..2.64 rows=1 width=678) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
21. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2009_q4_channel_id_published_idx on videos_y2009_q4 (cost=0.43..2.65 rows=1 width=703) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
22. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2010_q1_channel_id_published_idx on videos_y2010_q1 (cost=0.43..2.64 rows=1 width=699) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
23. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2010_q2_channel_id_published_idx on videos_y2010_q2 (cost=0.43..2.64 rows=1 width=703) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
24. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2010_q3_channel_id_published_idx on videos_y2010_q3 (cost=0.43..2.64 rows=1 width=711) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
25. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using videos_y2010_q4_channel_id_published_idx on videos_y2010_q4 (cost=0.43..2.64 rows=1 width=718) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
26. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2011_q1_channel_id_published_idx on videos_y2011_q1 (cost=0.43..2.64 rows=1 width=728) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
27. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2011_q2_channel_id_published_idx on videos_y2011_q2 (cost=0.43..2.65 rows=1 width=827) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
28. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using videos_y2011_q3_channel_id_published_idx on videos_y2011_q3 (cost=0.43..2.64 rows=1 width=752) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
29. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using videos_y2011_q4_channel_id_published_idx on videos_y2011_q4 (cost=0.43..2.65 rows=1 width=772) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
30. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2012_q1_channel_id_published_idx on videos_y2012_q1 (cost=0.43..2.65 rows=1 width=792) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
31. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2012_q2_channel_id_published_idx on videos_y2012_q2 (cost=0.43..2.65 rows=1 width=797) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
32. 0.010 0.010 ↓ 0.0 0 1

Index Scan Backward using videos_y2012_q3_channel_id_published_idx on videos_y2012_q3 (cost=0.43..2.65 rows=1 width=826) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
33. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2012_q4_published_idx on videos_y2012_q4 (cost=0.43..2.65 rows=1 width=842) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
34. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2013_q1_published_idx on videos_y2013_q1 (cost=0.43..2.65 rows=1 width=845) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
35. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using videos_y2013_q2_published_idx on videos_y2013_q2 (cost=0.43..2.65 rows=1 width=861) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
36. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2013_q3_published_idx on videos_y2013_q3 (cost=0.43..2.65 rows=1 width=879) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
37. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using videos_y2013_q4_published_idx on videos_y2013_q4 (cost=0.43..2.65 rows=1 width=900) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
38. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2014_q1_published_idx on videos_y2014_q1 (cost=0.43..2.65 rows=1 width=897) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
39. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using videos_y2014_q2_published_idx on videos_y2014_q2 (cost=0.43..2.65 rows=1 width=895) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
40. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2014_q3_published_idx on videos_y2014_q3 (cost=0.43..2.65 rows=1 width=905) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
41. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2014_q4_published_idx on videos_y2014_q4 (cost=0.43..2.65 rows=1 width=909) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
42. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2015_q1_published_idx on videos_y2015_q1 (cost=0.44..2.65 rows=1 width=897) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
43. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2015_q2_published_idx on videos_y2015_q2 (cost=0.44..2.65 rows=1 width=901) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
44. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2015_q3_published_idx on videos_y2015_q3 (cost=0.44..2.65 rows=1 width=891) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
45. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2015_q4_published_idx on videos_y2015_q4 (cost=0.44..2.66 rows=1 width=862) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
46. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2016_q1_published_idx on videos_y2016_q1 (cost=0.44..2.66 rows=1 width=827) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
47. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2016_q2_published_idx on videos_y2016_q2 (cost=0.44..2.66 rows=1 width=820) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
48. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2016_q3_published_idx on videos_y2016_q3 (cost=0.44..2.66 rows=1 width=802) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
49. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2016_q4_published_idx on videos_y2016_q4 (cost=0.44..2.66 rows=1 width=789) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
50. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using videos_y2017_q1_published_idx on videos_y2017_q1 (cost=0.44..2.66 rows=1 width=771) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
51. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2017_q2_published_idx on videos_y2017_q2 (cost=0.44..2.66 rows=1 width=747) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
52. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2017_q3_published_idx on videos_y2017_q3 (cost=0.44..2.66 rows=1 width=742) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
53. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using videos_y2017_q4_published_idx on videos_y2017_q4 (cost=0.44..2.66 rows=1 width=756) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
54. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2018_q1_published_idx on videos_y2018_q1 (cost=0.44..2.66 rows=1 width=729) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
55. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using videos_y2018_q2_published_idx on videos_y2018_q2 (cost=0.44..2.66 rows=1 width=734) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
56. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2018_q3_published_idx on videos_y2018_q3 (cost=0.44..2.66 rows=1 width=727) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
57. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using videos_y2018_q4_channel_id_published_idx on videos_y2018_q4 (cost=0.57..2.78 rows=1 width=745) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
58. 0.013 0.013 ↓ 0.0 0 1

Index Scan Backward using videos_y2019_q1_channel_id_published_idx on videos_y2019_q1 (cost=0.57..2.78 rows=1 width=752) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
59. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_y2019_q2_published_idx on videos_y2019_q2 (cost=0.57..2.78 rows=1 width=785) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
60. 0.024 0.024 ↑ 366.0 10 1

Index Scan Backward using videos_y2019_q3_channel_id_published_idx on videos_y2019_q3 (cost=0.57..4,142.66 rows=3,660 width=788) (actual time=0.017..0.024 rows=10 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
61. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using videos_y2019_q4_channel_id_published_idx on videos_y2019_q4 (cost=0.15..2.37 rows=1 width=457) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
62. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using videos_y2020_q1_channel_id_published_idx on videos_y2020_q1 (cost=0.15..2.37 rows=1 width=457) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
63. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using videos_y2020_q2_channel_id_published_idx on videos_y2020_q2 (cost=0.15..2.37 rows=1 width=457) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text) AND (published >= (now() - '60 days'::interval)))
64. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using videos_default_published_idx on videos_default (cost=0.42..1.54 rows=1 width=437) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (published >= (now() - '60 days'::interval))
  • Filter: (channel_id = 'UCKV0PostOmPjnXEbDgDYSFg'::text)
Planning time : 5.518 ms