explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jGJQ

Settings
# exclusive inclusive rows x rows loops node
1. 23.940 172,009.057 ↓ 40.5 5,266 1

Nested Loop (cost=3,566,315.36..3,691,430.04 rows=130 width=135) (actual time=156,191.673..172,009.057 rows=5,266 loops=1)

2. 2.547 168,525.355 ↓ 35.3 5,266 1

Merge Join (cost=3,566,315.36..3,612,042.75 rows=149 width=49) (actual time=156,112.919..168,525.355 rows=5,266 loops=1)

  • Merge Cond: (op.userid = op_1.userid)
3. 2.037 166,151.048 ↓ 30.7 6,792 1

Nested Loop (cost=2,150,634.80..2,182,100.60 rows=221 width=53) (actual time=153,842.820..166,151.048 rows=6,792 loops=1)

4. 1.293 153,843.788 ↓ 2.0 393 1

Unique (cost=2,150,634.36..2,151,269.48 rows=200 width=4) (actual time=153,840.657..153,843.788 rows=393 loops=1)

5.          

CTE base_user_bills

6. 180.244 152,986.539 ↓ 5.8 732,411 1

Gather (cost=2,115,836.64..2,133,802.62 rows=127,023 width=17) (actual time=152,514.143..152,986.539 rows=732,411 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
7. 181.443 152,806.295 ↓ 4.9 104,630 7 / 7

Merge Join (cost=2,114,836.64..2,119,306.43 rows=21,170 width=17) (actual time=152,500.014..152,806.295 rows=104,630 loops=7)

  • Merge Cond: (o_152.orderid = ub_1.orderid)
8. 274.388 1,083.849 ↑ 1.2 664,150 7 / 7

Sort (cost=1,330,068.71..1,332,003.69 rows=773,991 width=4) (actual time=1,002.410..1,083.849 rows=664,150 loops=7)

  • Sort Key: o_152.orderid
  • Sort Method: quicksort Memory: 56512kB
9. 51.710 809.461 ↑ 1.2 664,150 7 / 7

Append (cost=0.00..1,254,364.82 rows=773,991 width=4) (actual time=221.573..809.461 rows=664,150 loops=7)

10. 0.016 0.016 ↓ 0.0 0 7 / 7

Parallel Seq Scan on orders o_152 (cost=0.00..91.00 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=7)

  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
11. 0.006 0.006 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_history_i_order_create on orders_history o_153 (cost=0.44..8.18 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
12. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_01_i_order_create on orders_2014_01 o_154 (cost=0.42..6.70 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
13. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_11_i_order_create on orders_2014_11 o_155 (cost=0.43..7.50 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
14. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_02_i_order_create on orders_2014_02 o_156 (cost=0.42..6.82 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
15. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_03_i_order_create on orders_2014_03 o_157 (cost=0.43..6.55 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
16. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_08_i_order_create on orders_2014_08 o_158 (cost=0.43..6.91 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
17. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_05_i_order_create on orders_2014_05 o_159 (cost=0.43..7.00 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
18. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_10_i_order_create on orders_2014_10 o_160 (cost=0.43..7.63 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
19. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_09_i_order_create on orders_2014_09 o_161 (cost=0.43..6.26 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
20. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_12_i_order_create on orders_2014_12 o_162 (cost=0.43..7.53 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
21. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_07_i_order_create on orders_2014_07 o_163 (cost=0.43..7.06 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
22. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_06_i_order_create on orders_2014_06 o_164 (cost=0.43..7.07 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
23. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_04_i_order_create on orders_2014_04 o_165 (cost=0.43..6.64 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
24. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_06_i_order_create on orders_2015_06 o_166 (cost=0.43..4.76 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
25. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_01_i_order_create on orders_2015_01 o_167 (cost=0.43..7.66 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
26. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_04_i_order_create on orders_2015_04 o_168 (cost=0.43..5.52 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
27. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_02_i_order_create on orders_2015_02 o_169 (cost=0.43..7.51 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
28. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_05_i_order_create on orders_2015_05 o_170 (cost=0.43..4.89 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
29. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_07_i_order_create on orders_2015_07 o_171 (cost=0.43..6.76 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
30. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_03_i_order_create on orders_2015_03 o_172 (cost=0.43..7.48 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
31. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_08_i_order_create on orders_2015_08 o_173 (cost=0.43..7.87 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
32. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_09_i_order_create on orders_2015_09 o_174 (cost=0.43..7.28 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
33. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_10_i_order_create on orders_2015_10 o_175 (cost=0.43..7.59 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
34. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_11_i_order_create on orders_2015_11 o_176 (cost=0.43..8.12 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
35. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_12_i_order_create on orders_2015_12 o_177 (cost=0.43..7.62 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
36. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_01_i_order_create on orders_2016_01 o_178 (cost=0.43..7.12 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
37. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_02_i_order_create on orders_2016_02 o_179 (cost=0.43..6.25 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
38. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_03_i_order_create on orders_2016_03 o_180 (cost=0.43..6.28 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
39. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_04_i_order_create on orders_2016_04 o_181 (cost=0.43..6.18 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
40. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_05_i_order_create on orders_2016_05 o_182 (cost=0.43..6.59 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
41. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_06_i_order_create on orders_2016_06 o_183 (cost=0.43..6.54 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
42. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_07_i_order_create on orders_2016_07 o_184 (cost=0.43..6.43 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
43. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_08_i_order_create on orders_2016_08 o_185 (cost=0.43..6.91 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
44. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_09_i_order_create on orders_2016_09 o_186 (cost=0.43..6.52 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
45. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_10_i_order_create on orders_2016_10 o_187 (cost=0.43..6.43 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
46. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_11_i_order_create on orders_2016_11 o_188 (cost=0.43..6.83 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
47. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_12_i_order_create on orders_2016_12 o_189 (cost=0.43..6.50 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
48. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_01_i_order_create on orders_2017_01 o_190 (cost=0.43..7.94 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
49. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_02_i_order_create on orders_2017_02 o_191 (cost=0.43..7.93 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
50. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_03_i_order_create on orders_2017_03 o_192 (cost=0.43..8.11 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
51. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_04_i_order_create on orders_2017_04 o_193 (cost=0.43..8.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
52. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_05_i_order_create on orders_2017_05 o_194 (cost=0.43..7.87 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
53. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_06_i_order_create on orders_2017_06 o_195 (cost=0.43..8.08 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
54. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_07_i_order_create on orders_2017_07 o_196 (cost=0.43..8.43 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
55. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_08_i_order_create on orders_2017_08 o_197 (cost=0.43..7.93 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
56. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_09_i_order_create on orders_2017_09 o_198 (cost=0.43..8.44 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
57. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_10_i_order_create on orders_2017_10 o_199 (cost=0.43..7.69 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
58. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_11_i_order_create on orders_2017_11 o_200 (cost=0.43..8.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
59. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_12_i_order_create on orders_2017_12 o_201 (cost=0.43..4.78 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
60. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_01_i_order_create on orders_2018_01 o_202 (cost=0.43..4.98 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
61. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_02_i_order_create on orders_2018_02 o_203 (cost=0.43..5.08 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
62. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_03_i_order_create on orders_2018_03 o_204 (cost=0.43..4.76 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
63. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_04_i_order_create on orders_2018_04 o_205 (cost=0.43..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
64. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_05_i_order_create on orders_2018_05 o_206 (cost=0.43..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
65. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_06_i_order_create on orders_2018_06 o_207 (cost=0.43..4.75 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
66. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_07_i_order_create on orders_2018_07 o_208 (cost=0.43..4.78 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
67. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_08_i_order_create on orders_2018_08 o_209 (cost=0.43..4.75 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
68. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_09_i_order_create on orders_2018_09 o_210 (cost=0.43..4.83 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
69. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_10_i_order_create on orders_2018_10 o_211 (cost=0.43..5.08 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
70. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_11_i_order_create on orders_2018_11 o_212 (cost=0.43..4.73 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
71. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_12_i_order_create on orders_2018_12 o_213 (cost=0.44..4.80 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
72. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_01_i_order_create on orders_2019_01 o_214 (cost=0.44..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
73. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_02_i_order_create on orders_2019_02 o_215 (cost=0.44..4.82 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
74. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_03_i_order_create on orders_2019_03 o_216 (cost=0.56..5.20 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
75. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_04_i_order_create on orders_2019_04 o_217 (cost=0.56..5.41 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
76. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_05_i_order_create on orders_2019_05 o_218 (cost=0.56..4.93 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
77. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_06_i_order_create on orders_2019_06 o_219 (cost=0.56..4.92 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
78. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_07_i_order_create on orders_2019_07 o_220 (cost=0.56..5.37 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
79. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_08_i_order_create on orders_2019_08 o_221 (cost=0.56..5.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
80. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_09_i_order_create on orders_2019_09 o_222 (cost=0.56..5.01 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
81. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_10_i_order_create on orders_2019_10 o_223 (cost=0.56..7.06 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
82. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_11_i_order_create on orders_2019_11 o_224 (cost=0.56..7.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
83. 319.691 347.895 ↑ 1.2 21,072 7 / 7

Parallel Bitmap Heap Scan on orders_2019_12 o_225 (cost=33,710.95..576,234.39 rows=25,943 width=4) (actual time=221.466..347.895 rows=21,072 loops=7)

  • Recheck Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
  • Rows Removed by Filter: 17554
  • Heap Blocks: exact=22289
84. 28.204 28.204 ↓ 1.1 349,723 1 / 7

Bitmap Index Scan on orders_2019_12_i_order_create (cost=0.00..33,672.03 rows=306,596 width=0) (actual time=197.427..197.427 rows=349,723 loops=1)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
85. 409.737 409.737 ↑ 1.2 643,078 7 / 7

Parallel Seq Scan on orders_2020_01 o_226 (cost=0.00..677,566.64 rows=747,974 width=4) (actual time=0.007..409.737 rows=643,078 loops=7)

  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
  • Rows Removed by Filter: 627946
86. 0.025 0.025 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2020_02_status on orders_2020_02 o_227 (cost=0.14..8.16 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=7)

  • Index Cond: (status = 101)
  • Filter: (creation_date >= (CURRENT_DATE - '30 days'::interval))
87. 399.381 151,541.003 ↓ 5.8 733,796 7 / 7

Sort (cost=784,362.54..784,680.10 rows=127,023 width=24) (actual time=151,497.589..151,541.003 rows=733,796 loops=7)

  • Sort Key: ub_1.orderid
  • Sort Method: quicksort Memory: 81904kB
88. 151,141.622 151,141.622 ↓ 5.8 733,797 7 / 7

Index Scan using i_user_bills_reg_date on user_bills ub_1 (cost=0.57..773,594.33 rows=127,023 width=24) (actual time=0.551..151,141.622 rows=733,797 loops=7)

  • Index Cond: (reg_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((sellers_client_name IS NOT NULL) AND ((status)::text = 'AUTHORIZED'::text) AND ((sellers_type)::text = 'GENERIC_BILLPAYMENTS'::text))
  • Rows Removed by Filter: 2133108
89. 4.388 153,842.495 ↑ 10.3 12,386 1

Sort (cost=16,831.74..17,149.30 rows=127,023 width=4) (actual time=153,840.656..153,842.495 rows=12,386 loops=1)

  • Sort Key: ub.userid
  • Sort Method: quicksort Memory: 965kB
90. 69.765 153,838.107 ↑ 10.3 12,386 1

Hash Join (cost=3,182.57..6,063.53 rows=127,023 width=4) (actual time=153,711.193..153,838.107 rows=12,386 loops=1)

  • Hash Cond: (ub.cpf_beneficiario = x.cpf_beneficiario)
91. 152,571.331 152,571.331 ↓ 5.8 732,411 1

CTE Scan on base_user_bills ub (cost=0.00..2,540.46 rows=127,023 width=12) (actual time=152,514.146..152,571.331 rows=732,411 loops=1)

92. 0.123 1,197.011 ↓ 1.5 306 1

Hash (cost=3,180.07..3,180.07 rows=200 width=8) (actual time=1,197.011..1,197.011 rows=306 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
93. 0.076 1,196.888 ↓ 1.5 306 1

Subquery Scan on x (cost=3,175.57..3,180.07 rows=200 width=8) (actual time=1,026.868..1,196.888 rows=306 loops=1)

94. 533.515 1,196.812 ↓ 1.5 306 1

HashAggregate (cost=3,175.57..3,178.07 rows=200 width=40) (actual time=1,026.867..1,196.812 rows=306 loops=1)

  • Group Key: base_user_bills.cpf_beneficiario
  • Filter: (sum(base_user_bills.total) >= '10000'::numeric)
  • Rows Removed by Filter: 377355
95. 663.297 663.297 ↓ 5.8 732,411 1

CTE Scan on base_user_bills (cost=0.00..2,540.46 rows=127,023 width=28) (actual time=0.001..663.297 rows=732,411 loops=1)

96. 12,305.223 12,305.223 ↓ 17.0 17 393

Index Scan using i_offline_payments_userid on offline_payments op (cost=0.43..154.14 rows=1 width=49) (actual time=1.214..31.311 rows=17 loops=393)

  • Index Cond: (userid = ub.userid)
  • Filter: ((status = 3) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
  • Rows Removed by Filter: 92
97. 39.068 2,371.760 ↑ 90.9 729 1

Finalize GroupAggregate (cost=1,415,680.56..1,429,111.68 rows=66,274 width=36) (actual time=2,270.095..2,371.760 rows=729 loops=1)

  • Group Key: op_1.userid
  • Filter: (sum(op_1.amount) > '10000'::numeric)
  • Rows Removed by Filter: 39317
98. 65.008 2,332.692 ↑ 1.2 79,534 1

Gather Merge (cost=1,415,680.56..1,427,569.20 rows=95,208 width=36) (actual time=2,269.957..2,332.692 rows=79,534 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
99. 10.532 2,267.684 ↑ 1.3 12,010 7 / 7

Partial GroupAggregate (cost=1,414,680.47..1,414,997.83 rows=15,868 width=36) (actual time=2,253.953..2,267.684 rows=12,010 loops=7)

  • Group Key: op_1.userid
100. 9.962 2,257.152 ↓ 1.2 19,281 7 / 7

Sort (cost=1,414,680.47..1,414,720.14 rows=15,868 width=9) (actual time=2,253.944..2,257.152 rows=19,281 loops=7)

  • Sort Key: op_1.userid
  • Sort Method: quicksort Memory: 1814kB
101. 143.484 2,247.190 ↓ 1.2 19,459 7 / 7

Hash Join (cost=156,147.40..1,413,573.37 rows=15,868 width=9) (actual time=1,525.317..2,247.190 rows=19,459 loops=7)

  • Hash Cond: (o_76.orderid = op_1.orderid)
102. 58.204 669.476 ↑ 1.2 664,150 7 / 7

Append (cost=0.00..1,254,364.82 rows=773,991 width=4) (actual time=89.013..669.476 rows=664,150 loops=7)

103. 0.017 0.017 ↓ 0.0 0 7 / 7

Parallel Seq Scan on orders o_76 (cost=0.00..91.00 rows=1 width=4) (actual time=0.017..0.017 rows=0 loops=7)

  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
104. 0.006 0.006 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_history_i_order_create on orders_history o_77 (cost=0.44..8.18 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
105. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_01_i_order_create on orders_2014_01 o_78 (cost=0.42..6.70 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
106. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_11_i_order_create on orders_2014_11 o_79 (cost=0.43..7.50 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
107. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_02_i_order_create on orders_2014_02 o_80 (cost=0.42..6.82 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
108. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_03_i_order_create on orders_2014_03 o_81 (cost=0.43..6.55 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
109. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_08_i_order_create on orders_2014_08 o_82 (cost=0.43..6.91 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
110. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_05_i_order_create on orders_2014_05 o_83 (cost=0.43..7.00 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
111. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_10_i_order_create on orders_2014_10 o_84 (cost=0.43..7.63 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
112. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_09_i_order_create on orders_2014_09 o_85 (cost=0.43..6.26 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
113. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_12_i_order_create on orders_2014_12 o_86 (cost=0.43..7.53 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
114. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_07_i_order_create on orders_2014_07 o_87 (cost=0.43..7.06 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
115. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_06_i_order_create on orders_2014_06 o_88 (cost=0.43..7.07 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
116. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2014_04_i_order_create on orders_2014_04 o_89 (cost=0.43..6.64 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
117. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_06_i_order_create on orders_2015_06 o_90 (cost=0.43..4.76 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
118. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_01_i_order_create on orders_2015_01 o_91 (cost=0.43..7.66 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
119. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_04_i_order_create on orders_2015_04 o_92 (cost=0.43..5.52 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
120. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_02_i_order_create on orders_2015_02 o_93 (cost=0.43..7.51 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
121. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_05_i_order_create on orders_2015_05 o_94 (cost=0.43..4.89 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
122. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_07_i_order_create on orders_2015_07 o_95 (cost=0.43..6.76 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
123. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_03_i_order_create on orders_2015_03 o_96 (cost=0.43..7.48 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
124. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_08_i_order_create on orders_2015_08 o_97 (cost=0.43..7.87 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
125. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_09_i_order_create on orders_2015_09 o_98 (cost=0.43..7.28 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
126. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_10_i_order_create on orders_2015_10 o_99 (cost=0.43..7.59 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
127. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_11_i_order_create on orders_2015_11 o_100 (cost=0.43..8.12 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
128. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2015_12_i_order_create on orders_2015_12 o_101 (cost=0.43..7.62 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
129. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_01_i_order_create on orders_2016_01 o_102 (cost=0.43..7.12 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
130. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_02_i_order_create on orders_2016_02 o_103 (cost=0.43..6.25 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
131. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_03_i_order_create on orders_2016_03 o_104 (cost=0.43..6.28 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
132. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_04_i_order_create on orders_2016_04 o_105 (cost=0.43..6.18 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
133. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_05_i_order_create on orders_2016_05 o_106 (cost=0.43..6.59 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
134. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_06_i_order_create on orders_2016_06 o_107 (cost=0.43..6.54 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
135. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_07_i_order_create on orders_2016_07 o_108 (cost=0.43..6.43 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
136. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_08_i_order_create on orders_2016_08 o_109 (cost=0.43..6.91 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
137. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_09_i_order_create on orders_2016_09 o_110 (cost=0.43..6.52 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
138. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_10_i_order_create on orders_2016_10 o_111 (cost=0.43..6.43 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
139. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_11_i_order_create on orders_2016_11 o_112 (cost=0.43..6.83 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
140. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2016_12_i_order_create on orders_2016_12 o_113 (cost=0.43..6.50 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
141. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_01_i_order_create on orders_2017_01 o_114 (cost=0.43..7.94 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
142. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_02_i_order_create on orders_2017_02 o_115 (cost=0.43..7.93 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
143. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_03_i_order_create on orders_2017_03 o_116 (cost=0.43..8.11 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
144. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_04_i_order_create on orders_2017_04 o_117 (cost=0.43..8.02 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
145. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_05_i_order_create on orders_2017_05 o_118 (cost=0.43..7.87 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
146. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_06_i_order_create on orders_2017_06 o_119 (cost=0.43..8.08 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
147. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_07_i_order_create on orders_2017_07 o_120 (cost=0.43..8.43 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
148. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_08_i_order_create on orders_2017_08 o_121 (cost=0.43..7.93 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
149. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_09_i_order_create on orders_2017_09 o_122 (cost=0.43..8.44 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
150. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_10_i_order_create on orders_2017_10 o_123 (cost=0.43..7.69 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
151. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_11_i_order_create on orders_2017_11 o_124 (cost=0.43..8.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
152. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2017_12_i_order_create on orders_2017_12 o_125 (cost=0.43..4.78 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
153. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_01_i_order_create on orders_2018_01 o_126 (cost=0.43..4.98 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
154. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_02_i_order_create on orders_2018_02 o_127 (cost=0.43..5.08 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
155. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_03_i_order_create on orders_2018_03 o_128 (cost=0.43..4.76 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
156. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_04_i_order_create on orders_2018_04 o_129 (cost=0.43..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
157. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_05_i_order_create on orders_2018_05 o_130 (cost=0.43..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
158. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_06_i_order_create on orders_2018_06 o_131 (cost=0.43..4.75 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
159. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_07_i_order_create on orders_2018_07 o_132 (cost=0.43..4.78 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
160. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_08_i_order_create on orders_2018_08 o_133 (cost=0.43..4.75 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
161. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_09_i_order_create on orders_2018_09 o_134 (cost=0.43..4.83 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
162. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_10_i_order_create on orders_2018_10 o_135 (cost=0.43..5.08 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
163. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_11_i_order_create on orders_2018_11 o_136 (cost=0.43..4.73 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
164. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2018_12_i_order_create on orders_2018_12 o_137 (cost=0.44..4.80 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
165. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_01_i_order_create on orders_2019_01 o_138 (cost=0.44..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
166. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_02_i_order_create on orders_2019_02 o_139 (cost=0.44..4.82 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
167. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_03_i_order_create on orders_2019_03 o_140 (cost=0.56..5.20 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
168. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_04_i_order_create on orders_2019_04 o_141 (cost=0.56..5.41 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
169. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_05_i_order_create on orders_2019_05 o_142 (cost=0.56..4.93 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
170. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_06_i_order_create on orders_2019_06 o_143 (cost=0.56..4.92 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
171. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_07_i_order_create on orders_2019_07 o_144 (cost=0.56..5.37 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
172. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_08_i_order_create on orders_2019_08 o_145 (cost=0.56..5.02 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
173. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_09_i_order_create on orders_2019_09 o_146 (cost=0.56..5.01 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
174. 0.001 0.001 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_10_i_order_create on orders_2019_10 o_147 (cost=0.56..7.06 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
175. 0.002 0.002 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_11_i_order_create on orders_2019_11 o_148 (cost=0.56..7.02 rows=1 width=4) (actual time=0.001..0.002 rows=0 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
176. 167.918 176.252 ↑ 1.2 21,072 7 / 7

Parallel Bitmap Heap Scan on orders_2019_12 o_149 (cost=33,710.95..576,234.39 rows=25,943 width=4) (actual time=88.880..176.252 rows=21,072 loops=7)

  • Recheck Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 101)
  • Rows Removed by Filter: 17554
  • Heap Blocks: exact=52091
177. 8.334 8.334 ↓ 1.1 349,723 1 / 7

Bitmap Index Scan on orders_2019_12_i_order_create (cost=0.00..33,672.03 rows=306,596 width=0) (actual time=58.340..58.340 rows=349,723 loops=1)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
178. 434.887 434.887 ↑ 1.2 643,078 7 / 7

Parallel Seq Scan on orders_2020_01 o_150 (cost=0.00..677,566.64 rows=747,974 width=4) (actual time=0.007..434.887 rows=643,078 loops=7)

  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
  • Rows Removed by Filter: 627946
179. 0.025 0.025 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2020_02_status on orders_2020_02 o_151 (cost=0.14..8.16 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=7)

  • Index Cond: (status = 101)
  • Filter: (creation_date >= (CURRENT_DATE - '30 days'::interval))
180. 41.989 1,434.230 ↓ 1.3 136,246 7 / 7

Hash (cost=154,786.97..154,786.97 rows=108,834 width=13) (actual time=1,434.230..1,434.230 rows=136,246 loops=7)

  • Buckets: 262144 (originally 131072) Batches: 1 (originally 1) Memory Usage: 8435kB
181. 1,392.241 1,392.241 ↓ 1.3 136,246 7 / 7

Index Scan using i_offline_payments_creation_date on offline_payments op_1 (cost=0.44..154,786.97 rows=108,834 width=13) (actual time=0.085..1,392.241 rows=136,246 loops=7)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: (status = 3)
  • Rows Removed by Filter: 127505
182. 194.842 3,459.762 ↑ 76.0 1 5,266

Append (cost=0.00..532.04 rows=76 width=4) (actual time=0.651..0.657 rows=1 loops=5,266)

183. 210.640 210.640 ↓ 0.0 0 5,266

Seq Scan on orders o (cost=0.00..91.00 rows=1 width=4) (actual time=0.040..0.040 rows=0 loops=5,266)

  • Filter: ((status = 101) AND (op.orderid = orderid) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
184. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_history_pkey on orders_history o_1 (cost=0.43..6.53 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
185. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_01_pkey on orders_2014_01 o_2 (cost=0.42..6.21 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
186. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2014_11_pkey on orders_2014_11 o_3 (cost=0.42..6.27 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
187. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_02_pkey on orders_2014_02 o_4 (cost=0.42..6.21 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
188. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2014_03_pkey on orders_2014_03 o_5 (cost=0.42..6.23 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
189. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_08_pkey on orders_2014_08 o_6 (cost=0.42..6.25 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
190. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_05_pkey on orders_2014_05 o_7 (cost=0.42..6.24 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
191. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_10_pkey on orders_2014_10 o_8 (cost=0.42..6.28 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
192. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_09_pkey on orders_2014_09 o_9 (cost=0.42..6.26 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
193. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_12_pkey on orders_2014_12 o_10 (cost=0.42..6.29 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
194. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_07_pkey on orders_2014_07 o_11 (cost=0.42..6.24 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
195. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_06_pkey on orders_2014_06 o_12 (cost=0.42..6.24 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
196. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2014_04_pkey on orders_2014_04 o_13 (cost=0.42..6.24 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
197. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_06_i_order_create on orders_2015_06 o_14 (cost=0.43..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
198. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2015_01_pkey on orders_2015_01 o_15 (cost=0.43..6.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
199. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_04_i_order_create on orders_2015_04 o_16 (cost=0.43..5.53 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
200. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_02_pkey on orders_2015_02 o_17 (cost=0.43..6.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
201. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_05_i_order_create on orders_2015_05 o_18 (cost=0.43..4.90 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
202. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_07_pkey on orders_2015_07 o_19 (cost=0.43..6.34 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
203. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2015_03_pkey on orders_2015_03 o_20 (cost=0.43..6.33 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
204. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_08_pkey on orders_2015_08 o_21 (cost=0.43..6.34 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
205. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_09_pkey on orders_2015_09 o_22 (cost=0.43..6.35 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
206. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2015_10_pkey on orders_2015_10 o_23 (cost=0.43..6.35 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
207. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2015_11_pkey on orders_2015_11 o_24 (cost=0.43..6.35 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
208. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2015_12_pkey on orders_2015_12 o_25 (cost=0.43..6.36 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
209. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_01_pkey on orders_2016_01 o_26 (cost=0.43..6.36 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
210. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_02_i_order_create on orders_2016_02 o_27 (cost=0.43..6.26 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
211. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_03_i_order_create on orders_2016_03 o_28 (cost=0.43..6.29 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
212. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_04_i_order_create on orders_2016_04 o_29 (cost=0.43..6.19 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
213. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_05_pkey on orders_2016_05 o_30 (cost=0.43..6.38 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
214. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_06_pkey on orders_2016_06 o_31 (cost=0.43..6.38 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
215. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_07_pkey on orders_2016_07 o_32 (cost=0.43..6.39 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
216. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_08_pkey on orders_2016_08 o_33 (cost=0.43..6.40 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
217. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2016_09_pkey on orders_2016_09 o_34 (cost=0.43..6.38 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
218. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2016_10_pkey on orders_2016_10 o_35 (cost=0.43..6.38 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
219. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_11_pkey on orders_2016_11 o_36 (cost=0.43..6.38 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
220. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2016_12_pkey on orders_2016_12 o_37 (cost=0.43..6.38 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
221. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_01_pkey on orders_2017_01 o_38 (cost=0.43..6.39 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
222. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_02_pkey on orders_2017_02 o_39 (cost=0.43..6.39 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
223. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_03_pkey on orders_2017_03 o_40 (cost=0.43..6.39 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
224. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2017_04_pkey on orders_2017_04 o_41 (cost=0.43..6.39 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
225. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_05_pkey on orders_2017_05 o_42 (cost=0.43..6.41 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
226. 15.798 15.798 ↓ 0.0 0 5,266

Index Scan using orders_2017_06_pkey on orders_2017_06 o_43 (cost=0.43..6.41 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
227. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2017_07_pkey on orders_2017_07 o_44 (cost=0.43..6.43 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
228. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2017_08_pkey on orders_2017_08 o_45 (cost=0.43..6.44 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
229. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_09_pkey on orders_2017_09 o_46 (cost=0.43..6.46 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
230. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_10_pkey on orders_2017_10 o_47 (cost=0.43..6.47 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
231. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_11_pkey on orders_2017_11 o_48 (cost=0.43..6.46 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
232. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2017_12_i_order_create on orders_2017_12 o_49 (cost=0.43..4.78 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
233. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_01_i_order_create on orders_2018_01 o_50 (cost=0.43..4.98 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
234. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_02_i_order_create on orders_2018_02 o_51 (cost=0.43..5.09 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
235. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_03_i_order_create on orders_2018_03 o_52 (cost=0.43..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
236. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_04_i_order_create on orders_2018_04 o_53 (cost=0.43..4.77 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
237. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_05_i_order_create on orders_2018_05 o_54 (cost=0.43..4.78 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
238. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_06_i_order_create on orders_2018_06 o_55 (cost=0.43..4.75 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
239. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_07_i_order_create on orders_2018_07 o_56 (cost=0.43..4.79 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
240. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_08_i_order_create on orders_2018_08 o_57 (cost=0.43..4.76 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
241. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_09_i_order_create on orders_2018_09 o_58 (cost=0.43..4.83 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
242. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_10_i_order_create on orders_2018_10 o_59 (cost=0.43..5.08 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
243. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_11_i_order_create on orders_2018_11 o_60 (cost=0.43..4.74 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
244. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2018_12_i_order_create on orders_2018_12 o_61 (cost=0.44..4.81 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
245. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_01_i_order_create on orders_2019_01 o_62 (cost=0.44..4.78 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
246. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_02_i_order_create on orders_2019_02 o_63 (cost=0.44..4.83 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
247. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_03_i_order_create on orders_2019_03 o_64 (cost=0.56..5.21 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
248. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_04_i_order_create on orders_2019_04 o_65 (cost=0.56..5.41 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
249. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_05_i_order_create on orders_2019_05 o_66 (cost=0.56..4.94 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
250. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2019_06_i_order_create on orders_2019_06 o_67 (cost=0.56..4.92 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
251. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_07_i_order_create on orders_2019_07 o_68 (cost=0.56..5.38 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
252. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2019_08_i_order_create on orders_2019_08 o_69 (cost=0.56..5.03 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
253. 10.532 10.532 ↓ 0.0 0 5,266

Index Scan using orders_2019_09_i_order_create on orders_2019_09 o_70 (cost=0.56..5.01 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
254. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_10_i_order_create on orders_2019_10 o_71 (cost=0.56..7.07 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
255. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2019_11_i_order_create on orders_2019_11 o_72 (cost=0.56..7.03 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (creation_date >= (CURRENT_DATE - '30 days'::interval))
  • Filter: ((status = 101) AND (op.orderid = orderid))
256. 36.862 36.862 ↓ 0.0 0 5,266

Index Scan using orders_2019_12_pkey on orders_2019_12 o_73 (cost=0.56..7.52 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
257. 2,543.478 2,543.478 ↑ 1.0 1 5,266

Index Scan using orders_2020_01_pkey on orders_2020_01 o_74 (cost=0.56..7.46 rows=1 width=4) (actual time=0.478..0.483 rows=1 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
258. 5.266 5.266 ↓ 0.0 0 5,266

Index Scan using orders_2020_02_pkey on orders_2020_02 o_75 (cost=0.14..2.97 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=5,266)

  • Index Cond: (orderid = op.orderid)
  • Filter: ((status = 101) AND (creation_date >= (CURRENT_DATE - '30 days'::interval)))
Planning time : 311.349 ms
Execution time : 172,045.967 ms