explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ileK

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

Sort (cost=277,233.79..277,234.29 rows=200 width=60) (actual rows= loops=)

  • Sort Key: (min(ro.date))
2.          

CTE data

3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=274,668.50..274,676.50 rows=200 width=76) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=274,668.50..274,673.00 rows=200 width=36) (actual rows= loops=)

  • Group Key: daily_vars_new.cutoff_date
5. 0.000 0.000 ↓ 0.0

Sort (cost=274,668.50..274,669.00 rows=200 width=36) (actual rows= loops=)

  • Sort Key: daily_vars_new.cutoff_date
6. 0.000 0.000 ↓ 0.0

Gather (cost=274,638.36..274,660.86 rows=200 width=36) (actual rows= loops=)

  • Workers Planned: 1
7. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=273,638.36..273,640.86 rows=200 width=36) (actual rows= loops=)

  • Group Key: daily_vars_new.cutoff_date
8. 0.000 0.000 ↓ 0.0

Append (cost=0.00..272,912.37 rows=145,197 width=10) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on daily_vars_new (cost=0.00..0.00 rows=1 width=22) (actual rows= loops=)

  • Filter: (ndg = 31637761)
10. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_002_ndg_cutoff_date_idx on results_daily_vars_new_002 (cost=0.56..2,234.20 rows=1,175 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
11. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_003_ndg_cutoff_date_idx on results_daily_vars_new_003 (cost=0.56..2,108.22 rows=1,125 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
12. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_001_ndg_cutoff_date_idx on results_daily_vars_new_001 (cost=0.56..2,130.92 rows=1,121 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
13. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_006_ndg_cutoff_date_idx on results_daily_vars_new_006 (cost=0.56..2,059.31 rows=1,090 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
14. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_009_ndg_cutoff_date_idx on results_daily_vars_new_009 (cost=0.56..2,011.36 rows=1,069 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
15. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_004_ndg_cutoff_date_idx on results_daily_vars_new_004 (cost=0.56..2,418.17 rows=1,275 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
16. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_008_ndg_cutoff_date_idx on results_daily_vars_new_008 (cost=0.56..2,049.02 rows=1,079 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
17. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_010_ndg_cutoff_date_idx on results_daily_vars_new_010 (cost=0.56..2,054.22 rows=1,078 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
18. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_005_ndg_cutoff_date_idx on results_daily_vars_new_005 (cost=0.56..2,094.96 rows=1,126 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
19. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_007_ndg_cutoff_date_idx on results_daily_vars_new_007 (cost=0.56..2,084.52 rows=1,095 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
20. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_011_ndg_cutoff_date_idx on results_daily_vars_new_011 (cost=0.56..2,071.22 rows=1,090 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
21. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_012_ndg_cutoff_date_idx on results_daily_vars_new_012 (cost=0.56..1,994.83 rows=1,055 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
22. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_013_ndg_cutoff_date_idx on results_daily_vars_new_013 (cost=0.56..1,979.40 rows=1,041 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
23. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_014_ndg_cutoff_date_idx on results_daily_vars_new_014 (cost=0.56..2,029.96 rows=1,066 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
24. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_015_ndg_cutoff_date_idx on results_daily_vars_new_015 (cost=0.56..2,039.81 rows=1,071 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
25. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_016_ndg_cutoff_date_idx on results_daily_vars_new_016 (cost=0.56..2,048.93 rows=1,076 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
26. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_017_ndg_cutoff_date_idx on results_daily_vars_new_017 (cost=0.56..2,003.36 rows=1,078 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
27. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_018_ndg_cutoff_date_idx on results_daily_vars_new_018 (cost=0.56..2,041.08 rows=1,074 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
28. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_019_ndg_cutoff_date_idx on results_daily_vars_new_019 (cost=0.56..2,054.59 rows=1,079 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
29. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_020_ndg_cutoff_date_idx on results_daily_vars_new_020 (cost=0.56..2,049.25 rows=1,080 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
30. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_021_ndg_cutoff_date_idx on results_daily_vars_new_021 (cost=0.56..2,037.59 rows=1,070 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
31. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_022_ndg_cutoff_date_idx on results_daily_vars_new_022 (cost=0.56..2,006.59 rows=1,055 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
32. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_023_ndg_cutoff_date_idx on results_daily_vars_new_023 (cost=0.56..2,048.03 rows=1,076 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
33. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_024_ndg_cutoff_date_idx on results_daily_vars_new_024 (cost=0.56..2,036.99 rows=1,074 width=11) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
34. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_025_ndg_cutoff_date_idx on results_daily_vars_new_025 (cost=0.56..1,739.22 rows=1,104 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
35. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_026_ndg_cutoff_date_idx on results_daily_vars_new_026 (cost=0.56..2,056.46 rows=1,107 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
36. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_027_ndg_cutoff_date_idx on results_daily_vars_new_027 (cost=0.56..2,062.89 rows=1,085 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
37. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_028_ndg_cutoff_date_idx on results_daily_vars_new_028 (cost=0.56..2,071.61 rows=1,088 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
38. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_029_ndg_cutoff_date_idx on results_daily_vars_new_029 (cost=0.56..2,052.61 rows=1,079 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
39. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_030_ndg_cutoff_date_idx on results_daily_vars_new_030 (cost=0.56..2,065.00 rows=1,089 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
40. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_031_ndg_cutoff_date_idx on results_daily_vars_new_031 (cost=0.56..1,955.80 rows=1,041 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
41. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_032_ndg_cutoff_date_idx on results_daily_vars_new_032 (cost=0.56..1,996.52 rows=1,048 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
42. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_033_ndg_cutoff_date_idx on results_daily_vars_new_033 (cost=0.56..2,036.07 rows=1,073 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
43. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_034_ndg_cutoff_date_idx on results_daily_vars_new_034 (cost=0.56..2,040.46 rows=1,077 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
44. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_035_ndg_cutoff_date_idx on results_daily_vars_new_035 (cost=0.56..1,999.02 rows=1,059 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
45. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_036_ndg_cutoff_date_idx on results_daily_vars_new_036 (cost=0.56..2,038.56 rows=1,107 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
46. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_037_ndg_cutoff_date_idx on results_daily_vars_new_037 (cost=0.56..2,206.98 rows=1,160 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
47. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_038_ndg_cutoff_date_idx on results_daily_vars_new_038 (cost=0.56..2,195.98 rows=1,169 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
48. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_039_ndg_cutoff_date_idx on results_daily_vars_new_039 (cost=0.56..2,153.35 rows=1,132 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
49. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_040_ndg_cutoff_date_idx on results_daily_vars_new_040 (cost=0.56..2,140.64 rows=1,144 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
50. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_041_ndg_cutoff_date_idx on results_daily_vars_new_041 (cost=0.56..2,101.90 rows=1,162 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
51. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_042_ndg_cutoff_date_idx on results_daily_vars_new_042 (cost=0.56..2,178.88 rows=1,165 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
52. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_043_ndg_cutoff_date_idx on results_daily_vars_new_043 (cost=0.56..2,122.80 rows=1,132 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
53. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_044_ndg_cutoff_date_idx on results_daily_vars_new_044 (cost=0.56..2,035.13 rows=1,079 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
54. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_045_ndg_cutoff_date_idx on results_daily_vars_new_045 (cost=0.56..1,948.38 rows=1,051 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
55. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_046_ndg_cutoff_date_idx on results_daily_vars_new_046 (cost=0.56..1,786.55 rows=1,026 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
56. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_047_ndg_cutoff_date_idx on results_daily_vars_new_047 (cost=0.56..1,892.13 rows=1,008 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
57. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_048_ndg_cutoff_date_idx on results_daily_vars_new_048 (cost=0.56..1,830.98 rows=968 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
58. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_049_ndg_cutoff_date_idx on results_daily_vars_new_049 (cost=0.56..1,729.70 rows=927 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
59. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_050_ndg_cutoff_date_idx on results_daily_vars_new_050 (cost=0.56..1,656.97 rows=885 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
60. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_051_ndg_cutoff_date_idx on results_daily_vars_new_051 (cost=0.56..1,606.30 rows=858 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
61. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_052_ndg_cutoff_date_idx on results_daily_vars_new_052 (cost=0.56..1,469.42 rows=831 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
62. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_053_ndg_cutoff_date_idx on results_daily_vars_new_053 (cost=0.56..1,520.29 rows=801 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
63. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_054_ndg_cutoff_date_idx on results_daily_vars_new_054 (cost=0.56..1,426.18 rows=758 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
64. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_055_ndg_cutoff_date_idx on results_daily_vars_new_055 (cost=0.56..1,346.81 rows=719 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
65. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_056_ndg_cutoff_date_idx on results_daily_vars_new_056 (cost=0.56..1,273.71 rows=689 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
66. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_057_ndg_cutoff_date_idx on results_daily_vars_new_057 (cost=0.56..1,243.92 rows=664 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
67. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_058_ndg_cutoff_date_idx on results_daily_vars_new_058 (cost=0.56..1,147.35 rows=631 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
68. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_059_ndg_cutoff_date_idx on results_daily_vars_new_059 (cost=0.56..1,072.27 rows=612 width=9) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
69. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_060_ndg_cutoff_date_idx on results_daily_vars_new_060 (cost=0.56..1,101.13 rows=586 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
70. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_061_ndg_cutoff_date_idx on results_daily_vars_new_061 (cost=0.56..1,015.78 rows=544 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
71. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_062_ndg_cutoff_date_idx on results_daily_vars_new_062 (cost=0.56..946.84 rows=505 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
72. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_063_ndg_cutoff_date_idx on results_daily_vars_new_063 (cost=0.56..882.44 rows=472 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
73. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_064_ndg_cutoff_date_idx on results_daily_vars_new_064 (cost=0.56..812.61 rows=441 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
74. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_065_ndg_cutoff_date_idx on results_daily_vars_new_065 (cost=0.43..763.21 rows=413 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
75. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_066_ndg_cutoff_date_idx on results_daily_vars_new_066 (cost=0.43..714.27 rows=378 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
76. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_067_ndg_cutoff_date_idx on results_daily_vars_new_067 (cost=0.43..638.96 rows=339 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
77. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_068_ndg_cutoff_date_idx on results_daily_vars_new_068 (cost=0.43..583.93 rows=309 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
78. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_069_ndg_cutoff_date_idx on results_daily_vars_new_069 (cost=0.43..515.09 rows=274 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
79. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_070_ndg_cutoff_date_idx on results_daily_vars_new_070 (cost=0.43..446.52 rows=239 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
80. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_071_ndg_cutoff_date_idx on results_daily_vars_new_071 (cost=0.43..397.65 rows=209 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
81. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_072_ndg_cutoff_date_idx on results_daily_vars_new_072 (cost=0.43..329.27 rows=174 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
82. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_073_ndg_cutoff_date_idx on results_daily_vars_new_073 (cost=0.43..264.34 rows=139 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
83. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_074_ndg_cutoff_date_idx on results_daily_vars_new_074 (cost=0.43..192.79 rows=101 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
84. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_075_ndg_cutoff_date_idx on results_daily_vars_new_075 (cost=0.43..122.30 rows=65 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
85. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_076_ndg_cutoff_date_idx on results_daily_vars_new_076 (cost=0.56..1,963.54 rows=1,031 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
86. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_077_ndg_cutoff_date_idx on results_daily_vars_new_077 (cost=0.56..2,099.13 rows=1,102 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
87. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_078_ndg_cutoff_date_idx on results_daily_vars_new_078 (cost=0.56..2,102.81 rows=1,106 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
88. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_079_ndg_cutoff_date_idx on results_daily_vars_new_079 (cost=0.56..2,095.35 rows=1,100 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
89. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_080_ndg_cutoff_date_idx on results_daily_vars_new_080 (cost=0.56..2,074.42 rows=1,089 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
90. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_081_ndg_cutoff_date_idx on results_daily_vars_new_081 (cost=0.56..2,059.37 rows=1,089 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
91. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_082_ndg_cutoff_date_idx on results_daily_vars_new_082 (cost=0.56..2,067.53 rows=1,099 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
92. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_083_ndg_cutoff_date_idx on results_daily_vars_new_083 (cost=0.56..2,068.93 rows=1,086 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
93. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_084_ndg_cutoff_date_idx on results_daily_vars_new_084 (cost=0.56..2,014.40 rows=1,059 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
94. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_085_ndg_cutoff_date_idx on results_daily_vars_new_085 (cost=0.56..2,082.09 rows=1,094 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
95. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_086_ndg_cutoff_date_idx on results_daily_vars_new_086 (cost=0.56..2,010.80 rows=1,068 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
96. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_087_ndg_cutoff_date_idx on results_daily_vars_new_087 (cost=0.56..2,108.99 rows=1,108 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
97. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_088_ndg_cutoff_date_idx on results_daily_vars_new_088 (cost=0.56..2,074.63 rows=1,090 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
98. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_089_ndg_cutoff_date_idx on results_daily_vars_new_089 (cost=0.56..2,066.53 rows=1,088 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
99. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_090_ndg_cutoff_date_idx on results_daily_vars_new_090 (cost=0.56..2,030.31 rows=1,088 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
100. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_091_ndg_cutoff_date_idx on results_daily_vars_new_091 (cost=0.56..1,762.50 rows=1,055 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
101. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_092_ndg_cutoff_date_idx on results_daily_vars_new_092 (cost=0.56..1,787.22 rows=1,017 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
102. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_093_ndg_cutoff_date_idx on results_daily_vars_new_093 (cost=0.56..1,736.56 rows=983 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
103. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_094_ndg_cutoff_date_idx on results_daily_vars_new_094 (cost=0.56..1,697.32 rows=994 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
104. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_095_ndg_cutoff_date_idx on results_daily_vars_new_095 (cost=0.56..2,024.87 rows=1,071 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
105. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_096_ndg_cutoff_date_idx on results_daily_vars_new_096 (cost=0.56..2,062.89 rows=1,086 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
106. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_097_ndg_cutoff_date_idx on results_daily_vars_new_097 (cost=0.56..2,006.86 rows=1,054 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
107. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_098_ndg_cutoff_date_idx on results_daily_vars_new_098 (cost=0.56..1,977.59 rows=1,041 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
108. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_099_ndg_cutoff_date_idx on results_daily_vars_new_099 (cost=0.56..1,834.87 rows=1,082 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
109. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_100_ndg_cutoff_date_idx on results_daily_vars_new_100 (cost=0.56..2,130.46 rows=1,128 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
110. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_101_ndg_cutoff_date_idx on results_daily_vars_new_101 (cost=0.56..2,043.00 rows=1,075 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
111. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_102_ndg_cutoff_date_idx on results_daily_vars_new_102 (cost=0.56..2,096.57 rows=1,101 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
112. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_103_ndg_cutoff_date_idx on results_daily_vars_new_103 (cost=0.56..2,074.99 rows=1,101 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
113. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_104_ndg_cutoff_date_idx on results_daily_vars_new_104 (cost=0.56..2,126.60 rows=1,118 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
114. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_105_ndg_cutoff_date_idx on results_daily_vars_new_105 (cost=0.56..2,157.43 rows=1,135 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
115. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_106_ndg_cutoff_date_idx on results_daily_vars_new_106 (cost=0.56..2,152.35 rows=1,131 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
116. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_107_ndg_cutoff_date_idx on results_daily_vars_new_107 (cost=0.56..2,113.58 rows=1,122 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
117. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_108_ndg_cutoff_date_idx on results_daily_vars_new_108 (cost=0.56..2,167.07 rows=1,139 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
118. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_109_ndg_cutoff_date_idx on results_daily_vars_new_109 (cost=0.56..2,167.72 rows=1,139 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
119. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_110_ndg_cutoff_date_idx on results_daily_vars_new_110 (cost=0.56..2,175.08 rows=1,144 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
120. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_111_ndg_cutoff_date_idx on results_daily_vars_new_111 (cost=0.56..2,151.12 rows=1,134 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
121. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_112_ndg_cutoff_date_idx on results_daily_vars_new_112 (cost=0.56..2,125.92 rows=1,119 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
122. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_113_ndg_cutoff_date_idx on results_daily_vars_new_113 (cost=0.56..2,094.72 rows=1,104 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
123. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_114_ndg_cutoff_date_idx on results_daily_vars_new_114 (cost=0.56..2,145.17 rows=1,127 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
124. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_115_ndg_cutoff_date_idx on results_daily_vars_new_115 (cost=0.56..2,112.49 rows=1,111 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
125. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_116_ndg_cutoff_date_idx on results_daily_vars_new_116 (cost=0.56..2,087.60 rows=1,119 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
126. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_117_ndg_cutoff_date_idx on results_daily_vars_new_117 (cost=0.56..2,157.92 rows=1,133 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
127. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_118_ndg_cutoff_date_idx on results_daily_vars_new_118 (cost=0.56..2,079.97 rows=1,092 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
128. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_119_ndg_cutoff_date_idx on results_daily_vars_new_119 (cost=0.56..2,109.71 rows=1,111 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
129. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_120_ndg_cutoff_date_idx on results_daily_vars_new_120 (cost=0.56..2,148.77 rows=1,141 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
130. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_121_ndg_cutoff_date_idx on results_daily_vars_new_121 (cost=0.56..2,165.43 rows=1,139 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
131. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_122_ndg_cutoff_date_idx on results_daily_vars_new_122 (cost=0.56..2,173.42 rows=1,144 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
132. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_123_ndg_cutoff_date_idx on results_daily_vars_new_123 (cost=0.56..2,120.29 rows=1,115 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
133. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_124_ndg_cutoff_date_idx on results_daily_vars_new_124 (cost=0.56..2,109.83 rows=1,109 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
134. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_125_ndg_cutoff_date_idx on results_daily_vars_new_125 (cost=0.56..2,138.42 rows=1,125 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
135. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_126_ndg_cutoff_date_idx on results_daily_vars_new_126 (cost=0.56..2,150.24 rows=1,134 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
136. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_127_ndg_cutoff_date_idx on results_daily_vars_new_127 (cost=0.56..2,129.35 rows=1,122 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
137. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_128_ndg_cutoff_date_idx on results_daily_vars_new_128 (cost=0.56..2,180.37 rows=1,145 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
138. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_129_ndg_cutoff_date_idx on results_daily_vars_new_129 (cost=0.56..2,235.93 rows=1,259 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
139. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_130_ndg_cutoff_date_idx on results_daily_vars_new_130 (cost=0.56..2,319.53 rows=1,220 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
140. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_131_ndg_cutoff_date_idx on results_daily_vars_new_131 (cost=0.56..2,053.36 rows=1,091 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
141. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_132_ndg_cutoff_date_idx on results_daily_vars_new_132 (cost=0.56..2,165.46 rows=1,140 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
142. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_133_ndg_cutoff_date_idx on results_daily_vars_new_133 (cost=0.56..2,271.69 rows=1,196 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
143. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_134_ndg_cutoff_date_idx on results_daily_vars_new_134 (cost=0.56..2,099.39 rows=1,102 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
144. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_135_ndg_cutoff_date_idx on results_daily_vars_new_135 (cost=0.56..2,089.22 rows=1,102 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
145. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_136_ndg_cutoff_date_idx on results_daily_vars_new_136 (cost=0.56..2,090.58 rows=1,099 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
146. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_137_ndg_cutoff_date_idx on results_daily_vars_new_137 (cost=0.56..2,106.50 rows=1,106 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
147. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_138_ndg_cutoff_date_idx on results_daily_vars_new_138 (cost=0.56..2,073.49 rows=1,091 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
148. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_139_ndg_cutoff_date_idx on results_daily_vars_new_139 (cost=0.56..2,044.56 rows=1,074 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
149. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_140_ndg_cutoff_date_idx on results_daily_vars_new_140 (cost=0.56..2,028.37 rows=1,065 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
150. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_141_ndg_cutoff_date_idx on results_daily_vars_new_141 (cost=0.56..2,064.60 rows=1,084 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
151. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_142_ndg_cutoff_date_idx on results_daily_vars_new_142 (cost=0.56..2,289.98 rows=1,206 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
152. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_143_ndg_cutoff_date_idx on results_daily_vars_new_143 (cost=0.56..2,178.27 rows=1,184 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
153. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_144_ndg_cutoff_date_idx on results_daily_vars_new_144 (cost=0.56..1,513.85 rows=809 width=11) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
154. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_145_ndg_cutoff_date_idx on results_daily_vars_new_145 (cost=0.56..2,085.35 rows=1,096 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
155. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_146_ndg_cutoff_date_idx on results_daily_vars_new_146 (cost=0.56..2,088.71 rows=1,099 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
156. 0.000 0.000 ↓ 0.0

Parallel Index Scan using results_daily_vars_new_147_ndg_cutoff_date_idx on results_daily_vars_new_147 (cost=0.56..1,903.97 rows=1,002 width=10) (actual rows= loops=)

  • Index Cond: (ndg = 31637761)
157. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,278.14..2,549.64 rows=200 width=60) (actual rows= loops=)

  • Group Key: ((SubPlan 2))
158. 0.000 0.000 ↓ 0.0

Sort (cost=1,278.14..1,278.64 rows=200 width=52) (actual rows= loops=)

  • Sort Key: ((SubPlan 2))
159. 0.000 0.000 ↓ 0.0

CTE Scan on data ro (cost=0.00..1,270.50 rows=200 width=52) (actual rows= loops=)

160.          

SubPlan (forCTE Scan)

161. 0.000 0.000 ↓ 0.0

Limit (cost=6.33..6.33 rows=1 width=44) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Sort (cost=6.33..6.50 rows=66 width=44) (actual rows= loops=)

  • Sort Key: ri.date DESC, ri.state DESC
163. 0.000 0.000 ↓ 0.0

CTE Scan on data ri (cost=0.00..6.00 rows=66 width=44) (actual rows= loops=)

  • Filter: ((state <> ro.state) AND (ROW(date, state, id) < ROW(ro.date, ro.state, ro.id)))