explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tZXE

Settings
# exclusive inclusive rows x rows loops node
1. 1.081 97.520 ↑ 1.3 3,320 1

Append (cost=0.57..31,370.87 rows=4,457 width=59) (actual time=0.057..97.520 rows=3,320 loops=1)

2. 0.573 0.573 ↓ 3.9 244 1

Index Scan using bonusmoney_playerid_givendate_idx on payment.bonusmoney bm (cost=0.57..134.49 rows=62 width=53) (actual time=0.056..0.573 rows=244 loops=1)

  • Output: bm.givendate, bm.amount, 'BonusMoney'::text, (bm.type)::character(1)
  • Index Cond: ((bm.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (bm.givendate >= (CURRENT_DATE - '1 year'::interval)))
  • Filter: (bm.type IS DISTINCT FROM 3)
  • Rows Removed by Filter: 33
3. 1.448 24.478 ↑ 6.2 166 1

Nested Loop (cost=0.43..6,806.82 rows=1,026 width=80) (actual time=1.089..24.478 rows=166 loops=1)

  • Output: cp.createdat, (cp.net + cp.refund), 'CouponPrize'::text, (cp.state)::character(1)
4. 0.871 11.602 ↓ 2.7 2,857 1

Append (cost=0.00..2,173.10 rows=1,044 width=8) (actual time=0.431..11.602 rows=2,857 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on coupon.coupon c (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: c.newid
  • Filter: ((c.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c.recorddate >= (CURRENT_DATE - '1 year'::interval)))
6. 0.021 0.021 ↓ 0.0 0 1

Index Scan using coupon_p2010_2014_recorddate_idx on coupon.coupon_p2010_2014 c_1 (cost=0.57..4.47 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Output: c_1.newid
  • Index Cond: (c_1.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_1.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_1.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
7. 0.015 0.015 ↓ 0.0 0 1

Index Scan using coupon_p2017_01_recorddate_idx on coupon.coupon_p2017_01 c_2 (cost=0.43..2.64 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: c_2.newid
  • Index Cond: (c_2.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_2.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_2.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
8. 0.015 0.015 ↓ 0.0 0 1

Index Scan using coupon_p2017_02_recorddate_idx on coupon.coupon_p2017_02 c_3 (cost=0.43..2.64 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: c_3.newid
  • Index Cond: (c_3.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_3.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_3.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
9. 0.014 0.014 ↓ 0.0 0 1

Index Scan using coupon_p2017_03_recorddate_idx on coupon.coupon_p2017_03 c_4 (cost=0.43..2.59 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Output: c_4.newid
  • Index Cond: (c_4.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_4.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_4.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
10. 0.013 0.013 ↓ 0.0 0 1

Index Scan using coupon_p2017_04_recorddate_idx on coupon.coupon_p2017_04 c_5 (cost=0.43..2.54 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: c_5.newid
  • Index Cond: (c_5.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_5.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_5.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
11. 0.020 0.020 ↓ 0.0 0 1

Index Scan using coupon_p2017_05_recorddate_idx on coupon.coupon_p2017_05 c_6 (cost=0.43..2.54 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: c_6.newid
  • Index Cond: (c_6.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_6.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_6.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
12. 0.014 0.014 ↓ 0.0 0 1

Index Scan using coupon_p2017_06_recorddate_idx on coupon.coupon_p2017_06 c_7 (cost=0.43..2.54 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Output: c_7.newid
  • Index Cond: (c_7.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_7.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_7.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
13. 0.018 0.018 ↓ 0.0 0 1

Index Scan using coupon_p2017_07_recorddate_idx on coupon.coupon_p2017_07 c_8 (cost=0.43..2.56 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: c_8.newid
  • Index Cond: (c_8.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_8.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_8.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
14. 0.012 0.012 ↓ 0.0 0 1

Index Scan using coupon_p2017_08_recorddate_idx on coupon.coupon_p2017_08 c_9 (cost=0.43..2.55 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Output: c_9.newid
  • Index Cond: (c_9.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_9.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_9.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
15. 0.014 0.014 ↓ 0.0 0 1

Index Scan using coupon_p2017_09_recorddate_idx on coupon.coupon_p2017_09 c_10 (cost=0.43..2.54 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Output: c_10.newid
  • Index Cond: (c_10.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_10.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_10.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
16. 0.019 0.019 ↓ 0.0 0 1

Index Scan using coupon_p2017_10_recorddate_idx on coupon.coupon_p2017_10 c_11 (cost=0.43..2.56 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Output: c_11.newid
  • Index Cond: (c_11.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_11.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_11.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
17. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2017_11_recorddate_idx on coupon.coupon_p2017_11 c_12 (cost=0.43..2.54 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_12.newid
  • Index Cond: (c_12.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_12.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_12.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
18. 0.015 0.015 ↓ 0.0 0 1

Index Scan using coupon_p2017_12_recorddate_idx on coupon.coupon_p2017_12 c_13 (cost=0.43..2.55 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: c_13.newid
  • Index Cond: (c_13.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_13.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_13.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
19. 0.021 0.021 ↓ 0.0 0 1

Index Scan using coupon_p2015_recorddate_idx on coupon.coupon_p2015 c_14 (cost=0.44..2.50 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Output: c_14.newid
  • Index Cond: (c_14.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_14.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_14.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
20. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2016_recorddate_idx on coupon.coupon_p2016 c_15 (cost=0.44..2.49 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_15.newid
  • Index Cond: (c_15.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_15.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_15.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
21. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2018_01_recorddate_idx on coupon.coupon_p2018_01 c_16 (cost=0.43..2.55 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_16.newid
  • Index Cond: (c_16.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_16.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_16.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
22. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2018_02_recorddate_idx on coupon.coupon_p2018_02 c_17 (cost=0.43..2.56 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_17.newid
  • Index Cond: (c_17.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_17.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_17.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
23. 0.015 0.015 ↓ 0.0 0 1

Index Scan using coupon_p2018_03_recorddate_idx on coupon.coupon_p2018_03 c_18 (cost=0.43..2.57 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: c_18.newid
  • Index Cond: (c_18.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_18.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_18.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
24. 0.014 0.014 ↓ 0.0 0 1

Index Scan using coupon_p2018_04_recorddate_idx on coupon.coupon_p2018_04 c_19 (cost=0.43..2.54 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Output: c_19.newid
  • Index Cond: (c_19.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_19.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_19.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
25. 0.014 0.014 ↓ 0.0 0 1

Index Scan using coupon_p2018_05_recorddate_idx on coupon.coupon_p2018_05 c_20 (cost=0.43..2.57 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Output: c_20.newid
  • Index Cond: (c_20.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_20.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_20.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
26. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2018_06_recorddate_idx on coupon.coupon_p2018_06 c_21 (cost=0.43..2.76 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_21.newid
  • Index Cond: (c_21.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_21.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_21.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
27. 0.015 0.015 ↓ 0.0 0 1

Index Scan using coupon_p2018_07_recorddate_idx on coupon.coupon_p2018_07 c_22 (cost=0.43..2.53 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: c_22.newid
  • Index Cond: (c_22.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_22.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_22.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
28. 0.017 0.017 ↓ 0.0 0 1

Index Scan using coupon_p2018_08_recorddate_idx on coupon.coupon_p2018_08 c_23 (cost=0.43..2.58 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Output: c_23.newid
  • Index Cond: (c_23.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: ((c_23.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_23.coupontypeid = ANY ('{1,2,4,5}'::integer[])))
29. 0.201 0.231 ↑ 1.1 58 1

Bitmap Heap Scan on coupon.coupon_p2018_09 c_24 (cost=3.08..171.93 rows=63 width=8) (actual time=0.055..0.231 rows=58 loops=1)

  • Output: c_24.newid
  • Recheck Cond: (c_24.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_24.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_24.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=58
30. 0.030 0.030 ↑ 1.5 58 1

Bitmap Index Scan on coupon_p2018_09_playeridfki (cost=0.00..3.07 rows=85 width=0) (actual time=0.030..0.030 rows=58 loops=1)

  • Index Cond: (c_24.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
31. 0.754 0.798 ↓ 2.3 213 1

Bitmap Heap Scan on coupon.coupon_p2018_10 c_25 (cost=3.16..189.93 rows=94 width=8) (actual time=0.071..0.798 rows=213 loops=1)

  • Output: c_25.newid
  • Recheck Cond: (c_25.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_25.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_25.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=210
32. 0.044 0.044 ↓ 2.3 213 1

Bitmap Index Scan on coupon_p2018_10_playeridfki (cost=0.00..3.14 rows=94 width=0) (actual time=0.044..0.044 rows=213 loops=1)

  • Index Cond: (c_25.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
33. 1.075 1.174 ↓ 3.5 324 1

Bitmap Heap Scan on coupon.coupon_p2018_11 c_26 (cost=3.15..187.92 rows=93 width=8) (actual time=0.147..1.174 rows=324 loops=1)

  • Output: c_26.newid
  • Recheck Cond: (c_26.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_26.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_26.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=322
34. 0.099 0.099 ↓ 3.5 324 1

Bitmap Index Scan on coupon_p2018_11_playeridfki (cost=0.00..3.13 rows=93 width=0) (actual time=0.099..0.099 rows=324 loops=1)

  • Index Cond: (c_26.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
35. 0.015 0.026 ↑ 22.0 4 1

Bitmap Heap Scan on coupon.coupon_p2018_12 c_27 (cost=3.11..177.96 rows=88 width=8) (actual time=0.017..0.026 rows=4 loops=1)

  • Output: c_27.newid
  • Recheck Cond: (c_27.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_27.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_27.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=4
36. 0.011 0.011 ↑ 22.0 4 1

Bitmap Index Scan on coupon_p2018_12_playeridfki (cost=0.00..3.09 rows=88 width=0) (actual time=0.011..0.011 rows=4 loops=1)

  • Index Cond: (c_27.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
37. 0.572 0.613 ↓ 1.9 175 1

Bitmap Heap Scan on coupon.coupon_p2019_01 c_28 (cost=3.15..187.64 rows=93 width=8) (actual time=0.068..0.613 rows=175 loops=1)

  • Output: c_28.newid
  • Recheck Cond: (c_28.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_28.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_28.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=174
38. 0.041 0.041 ↓ 1.9 175 1

Bitmap Index Scan on coupon_p2019_01_playeridfki (cost=0.00..3.13 rows=93 width=0) (actual time=0.041..0.041 rows=175 loops=1)

  • Index Cond: (c_28.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
39. 0.675 0.729 ↓ 2.6 214 1

Bitmap Heap Scan on coupon.coupon_p2019_02 c_29 (cost=3.07..165.95 rows=82 width=8) (actual time=0.084..0.729 rows=214 loops=1)

  • Output: c_29.newid
  • Recheck Cond: (c_29.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_29.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_29.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=210
40. 0.054 0.054 ↓ 2.6 214 1

Bitmap Index Scan on coupon_p2019_02_playeridfki (cost=0.00..3.05 rows=82 width=0) (actual time=0.054..0.054 rows=214 loops=1)

  • Index Cond: (c_29.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
41. 0.571 0.640 ↓ 1.9 169 1

Bitmap Heap Scan on coupon.coupon_p2019_03 c_30 (cost=3.12..179.86 rows=88 width=8) (actual time=0.095..0.640 rows=169 loops=1)

  • Output: c_30.newid
  • Recheck Cond: (c_30.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_30.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_30.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=168
42. 0.069 0.069 ↓ 1.9 169 1

Bitmap Index Scan on coupon_p2019_03_playeridfki (cost=0.00..3.10 rows=89 width=0) (actual time=0.069..0.069 rows=169 loops=1)

  • Index Cond: (c_30.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
43. 1.254 1.357 ↓ 3.5 312 1

Bitmap Heap Scan on coupon.coupon_p2019_04 c_31 (cost=3.11..177.75 rows=88 width=8) (actual time=0.149..1.357 rows=312 loops=1)

  • Output: c_31.newid
  • Recheck Cond: (c_31.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_31.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_31.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=308
44. 0.103 0.103 ↓ 3.5 312 1

Bitmap Index Scan on coupon_p2019_04_playeridfki (cost=0.00..3.09 rows=88 width=0) (actual time=0.103..0.103 rows=312 loops=1)

  • Index Cond: (c_31.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
45. 0.259 0.279 ↑ 1.1 75 1

Bitmap Heap Scan on coupon.coupon_p2019_05 c_32 (cost=3.05..162.32 rows=80 width=8) (actual time=0.043..0.279 rows=75 loops=1)

  • Output: c_32.newid
  • Recheck Cond: (c_32.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_32.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_32.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=75
46. 0.020 0.020 ↑ 1.1 75 1

Bitmap Index Scan on coupon_p2019_05_playeridfki (cost=0.00..3.03 rows=80 width=0) (actual time=0.020..0.020 rows=75 loops=1)

  • Index Cond: (c_32.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
47. 1.222 1.330 ↓ 6.5 387 1

Bitmap Heap Scan on coupon.coupon_p2019_06 c_33 (cost=2.90..123.61 rows=60 width=8) (actual time=0.161..1.330 rows=387 loops=1)

  • Output: c_33.newid
  • Recheck Cond: (c_33.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_33.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_33.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=377
48. 0.108 0.108 ↓ 6.3 387 1

Bitmap Index Scan on coupon_p2019_06_playeridfki (cost=0.00..2.89 rows=61 width=0) (actual time=0.108..0.108 rows=387 loops=1)

  • Index Cond: (c_33.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
49. 0.518 0.545 ↓ 2.2 151 1

Bitmap Heap Scan on coupon.coupon_p2019_07 c_34 (cost=2.95..137.46 rows=68 width=8) (actual time=0.054..0.545 rows=151 loops=1)

  • Output: c_34.newid
  • Recheck Cond: (c_34.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_34.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_34.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=149
50. 0.027 0.027 ↓ 2.2 151 1

Bitmap Index Scan on coupon_p2019_07_playeridfki (cost=0.00..2.94 rows=68 width=0) (actual time=0.027..0.027 rows=151 loops=1)

  • Index Cond: (c_34.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
51. 2.095 2.314 ↓ 8.3 678 1

Bitmap Heap Scan on coupon.coupon_p2019_08 c_35 (cost=3.07..165.89 rows=82 width=8) (actual time=0.314..2.314 rows=678 loops=1)

  • Output: c_35.newid
  • Recheck Cond: (c_35.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_35.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_35.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=661
52. 0.219 0.219 ↓ 8.3 678 1

Bitmap Index Scan on coupon_p2019_08_playeridfki (cost=0.00..3.05 rows=82 width=0) (actual time=0.219..0.219 rows=678 loops=1)

  • Index Cond: (c_35.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
53. 0.303 0.326 ↓ 2.4 97 1

Bitmap Heap Scan on coupon.coupon_p2019_09 c_36 (cost=2.74..83.96 rows=41 width=8) (actual time=0.045..0.326 rows=97 loops=1)

  • Output: c_36.newid
  • Recheck Cond: (c_36.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: ((c_36.coupontypeid = ANY ('{1,2,4,5}'::integer[])) AND (c_36.recorddate >= (CURRENT_DATE - '1 year'::interval)))
  • Heap Blocks: exact=92
54. 0.023 0.023 ↓ 2.4 97 1

Bitmap Index Scan on coupon_p2019_09_playeridfki (cost=0.00..2.73 rows=41 width=0) (actual time=0.023..0.023 rows=97 loops=1)

  • Index Cond: (c_36.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
55. 11.428 11.428 ↓ 0.0 0 2,857

Index Scan using couponprize_couponnewid_idx on coupon.couponprize cp (cost=0.43..4.42 rows=1 width=29) (actual time=0.004..0.004 rows=0 loops=2,857)

  • Output: cp.createdat, cp.net, cp.refund, cp.state, cp.couponnewid
  • Index Cond: (cp.couponnewid = c.newid)
  • Filter: (cp.net <> '0'::numeric)
  • Rows Removed by Filter: 0
56. 4.346 70.959 ↑ 1.2 2,726 1

Nested Loop (cost=0.00..24,328.42 rows=3,315 width=53) (actual time=0.817..70.959 rows=2,726 loops=1)

  • Output: ct.actiondate, ct.amount, 'CouponTransaction'::text, (ct.couponnewid)::character(1)
57. 1.084 12.330 ↓ 2.7 2,857 1

Append (cost=0.00..2,167.76 rows=1,046 width=8) (actual time=0.488..12.330 rows=2,857 loops=1)

58. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on coupon.coupon c_37 (cost=0.00..0.00 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: c_37.newid
  • Filter: ((c_37.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (c_37.recorddate >= (CURRENT_DATE - '1 year'::interval)))
59. 0.013 0.013 ↓ 0.0 0 1

Index Scan using coupon_p2010_2014_recorddate_idx on coupon.coupon_p2010_2014 c_38 (cost=0.57..4.46 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: c_38.newid
  • Index Cond: (c_38.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_38.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
60. 0.009 0.009 ↓ 0.0 0 1

Index Scan using coupon_p2017_01_recorddate_idx on coupon.coupon_p2017_01 c_39 (cost=0.43..2.63 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: c_39.newid
  • Index Cond: (c_39.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_39.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
61. 0.023 0.023 ↓ 0.0 0 1

Index Scan using coupon_p2017_02_recorddate_idx on coupon.coupon_p2017_02 c_40 (cost=0.43..2.64 rows=1 width=8) (actual time=0.023..0.023 rows=0 loops=1)

  • Output: c_40.newid
  • Index Cond: (c_40.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_40.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
62. 0.014 0.014 ↓ 0.0 0 1

Index Scan using coupon_p2017_03_recorddate_idx on coupon.coupon_p2017_03 c_41 (cost=0.43..2.58 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Output: c_41.newid
  • Index Cond: (c_41.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_41.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
63. 0.022 0.022 ↓ 0.0 0 1

Index Scan using coupon_p2017_04_recorddate_idx on coupon.coupon_p2017_04 c_42 (cost=0.43..2.54 rows=1 width=8) (actual time=0.022..0.022 rows=0 loops=1)

  • Output: c_42.newid
  • Index Cond: (c_42.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_42.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
64. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2017_05_recorddate_idx on coupon.coupon_p2017_05 c_43 (cost=0.43..2.54 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_43.newid
  • Index Cond: (c_43.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_43.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
65. 0.020 0.020 ↓ 0.0 0 1

Index Scan using coupon_p2017_06_recorddate_idx on coupon.coupon_p2017_06 c_44 (cost=0.43..2.54 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: c_44.newid
  • Index Cond: (c_44.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_44.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
66. 0.021 0.021 ↓ 0.0 0 1

Index Scan using coupon_p2017_07_recorddate_idx on coupon.coupon_p2017_07 c_45 (cost=0.43..2.55 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Output: c_45.newid
  • Index Cond: (c_45.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_45.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
67. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2017_08_recorddate_idx on coupon.coupon_p2017_08 c_46 (cost=0.43..2.54 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_46.newid
  • Index Cond: (c_46.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_46.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
68. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2017_09_recorddate_idx on coupon.coupon_p2017_09 c_47 (cost=0.43..2.54 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_47.newid
  • Index Cond: (c_47.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_47.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
69. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2017_10_recorddate_idx on coupon.coupon_p2017_10 c_48 (cost=0.43..2.55 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_48.newid
  • Index Cond: (c_48.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_48.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
70. 0.022 0.022 ↓ 0.0 0 1

Index Scan using coupon_p2017_11_recorddate_idx on coupon.coupon_p2017_11 c_49 (cost=0.43..2.54 rows=1 width=8) (actual time=0.022..0.022 rows=0 loops=1)

  • Output: c_49.newid
  • Index Cond: (c_49.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_49.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
71. 0.019 0.019 ↓ 0.0 0 1

Index Scan using coupon_p2017_12_recorddate_idx on coupon.coupon_p2017_12 c_50 (cost=0.43..2.54 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Output: c_50.newid
  • Index Cond: (c_50.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_50.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
72. 0.018 0.018 ↓ 0.0 0 1

Index Scan using coupon_p2015_recorddate_idx on coupon.coupon_p2015 c_51 (cost=0.44..2.50 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: c_51.newid
  • Index Cond: (c_51.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_51.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
73. 0.017 0.017 ↓ 0.0 0 1

Index Scan using coupon_p2016_recorddate_idx on coupon.coupon_p2016 c_52 (cost=0.44..2.48 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Output: c_52.newid
  • Index Cond: (c_52.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_52.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
74. 0.020 0.020 ↓ 0.0 0 1

Index Scan using coupon_p2018_01_recorddate_idx on coupon.coupon_p2018_01 c_53 (cost=0.43..2.55 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: c_53.newid
  • Index Cond: (c_53.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_53.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
75. 0.018 0.018 ↓ 0.0 0 1

Index Scan using coupon_p2018_02_recorddate_idx on coupon.coupon_p2018_02 c_54 (cost=0.43..2.55 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: c_54.newid
  • Index Cond: (c_54.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_54.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
76. 0.018 0.018 ↓ 0.0 0 1

Index Scan using coupon_p2018_03_recorddate_idx on coupon.coupon_p2018_03 c_55 (cost=0.43..2.56 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: c_55.newid
  • Index Cond: (c_55.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_55.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
77. 0.020 0.020 ↓ 0.0 0 1

Index Scan using coupon_p2018_04_recorddate_idx on coupon.coupon_p2018_04 c_56 (cost=0.43..2.53 rows=1 width=8) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: c_56.newid
  • Index Cond: (c_56.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_56.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
78. 0.018 0.018 ↓ 0.0 0 1

Index Scan using coupon_p2018_05_recorddate_idx on coupon.coupon_p2018_05 c_57 (cost=0.43..2.56 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: c_57.newid
  • Index Cond: (c_57.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_57.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
79. 0.021 0.021 ↓ 0.0 0 1

Index Scan using coupon_p2018_06_recorddate_idx on coupon.coupon_p2018_06 c_58 (cost=0.43..2.76 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Output: c_58.newid
  • Index Cond: (c_58.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_58.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
80. 0.015 0.015 ↓ 0.0 0 1

Index Scan using coupon_p2018_07_recorddate_idx on coupon.coupon_p2018_07 c_59 (cost=0.43..2.53 rows=1 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: c_59.newid
  • Index Cond: (c_59.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_59.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
81. 0.016 0.016 ↓ 0.0 0 1

Index Scan using coupon_p2018_08_recorddate_idx on coupon.coupon_p2018_08 c_60 (cost=0.43..2.58 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: c_60.newid
  • Index Cond: (c_60.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Filter: (c_60.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
82. 0.206 0.233 ↑ 1.1 58 1

Bitmap Heap Scan on coupon.coupon_p2018_09 c_61 (cost=3.08..171.51 rows=63 width=8) (actual time=0.056..0.233 rows=58 loops=1)

  • Output: c_61.newid
  • Recheck Cond: (c_61.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_61.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=58
83. 0.027 0.027 ↑ 1.5 58 1

Bitmap Index Scan on coupon_p2018_09_playeridfki (cost=0.00..3.07 rows=85 width=0) (actual time=0.027..0.027 rows=58 loops=1)

  • Index Cond: (c_61.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
84. 0.706 0.755 ↓ 2.3 213 1

Bitmap Heap Scan on coupon.coupon_p2018_10 c_62 (cost=3.16..189.46 rows=94 width=8) (actual time=0.086..0.755 rows=213 loops=1)

  • Output: c_62.newid
  • Recheck Cond: (c_62.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_62.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=210
85. 0.049 0.049 ↓ 2.3 213 1

Bitmap Index Scan on coupon_p2018_10_playeridfki (cost=0.00..3.14 rows=94 width=0) (actual time=0.049..0.049 rows=213 loops=1)

  • Index Cond: (c_62.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
86. 1.114 1.214 ↓ 3.5 324 1

Bitmap Heap Scan on coupon.coupon_p2018_11 c_63 (cost=3.15..187.46 rows=93 width=8) (actual time=0.146..1.214 rows=324 loops=1)

  • Output: c_63.newid
  • Recheck Cond: (c_63.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_63.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=322
87. 0.100 0.100 ↓ 3.5 324 1

Bitmap Index Scan on coupon_p2018_11_playeridfki (cost=0.00..3.13 rows=93 width=0) (actual time=0.100..0.100 rows=324 loops=1)

  • Index Cond: (c_63.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
88. 0.014 0.025 ↑ 22.0 4 1

Bitmap Heap Scan on coupon.coupon_p2018_12 c_64 (cost=3.11..177.52 rows=88 width=8) (actual time=0.017..0.025 rows=4 loops=1)

  • Output: c_64.newid
  • Recheck Cond: (c_64.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_64.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=4
89. 0.011 0.011 ↑ 22.0 4 1

Bitmap Index Scan on coupon_p2018_12_playeridfki (cost=0.00..3.09 rows=88 width=0) (actual time=0.011..0.011 rows=4 loops=1)

  • Index Cond: (c_64.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
90. 0.622 0.672 ↓ 1.9 175 1

Bitmap Heap Scan on coupon.coupon_p2019_01 c_65 (cost=3.15..187.18 rows=93 width=8) (actual time=0.098..0.672 rows=175 loops=1)

  • Output: c_65.newid
  • Recheck Cond: (c_65.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_65.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=174
91. 0.050 0.050 ↓ 1.9 175 1

Bitmap Index Scan on coupon_p2019_01_playeridfki (cost=0.00..3.13 rows=93 width=0) (actual time=0.050..0.050 rows=175 loops=1)

  • Index Cond: (c_65.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
92. 0.754 0.806 ↓ 2.6 214 1

Bitmap Heap Scan on coupon.coupon_p2019_02 c_66 (cost=3.07..165.54 rows=82 width=8) (actual time=0.084..0.806 rows=214 loops=1)

  • Output: c_66.newid
  • Recheck Cond: (c_66.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_66.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=210
93. 0.052 0.052 ↓ 2.6 214 1

Bitmap Index Scan on coupon_p2019_02_playeridfki (cost=0.00..3.05 rows=82 width=0) (actual time=0.052..0.052 rows=214 loops=1)

  • Index Cond: (c_66.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
94. 0.594 0.662 ↓ 1.9 169 1

Bitmap Heap Scan on coupon.coupon_p2019_03 c_67 (cost=3.12..179.42 rows=89 width=8) (actual time=0.091..0.662 rows=169 loops=1)

  • Output: c_67.newid
  • Recheck Cond: (c_67.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_67.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=168
95. 0.068 0.068 ↓ 1.9 169 1

Bitmap Index Scan on coupon_p2019_03_playeridfki (cost=0.00..3.10 rows=89 width=0) (actual time=0.068..0.068 rows=169 loops=1)

  • Index Cond: (c_67.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
96. 1.092 1.193 ↓ 3.5 312 1

Bitmap Heap Scan on coupon.coupon_p2019_04 c_68 (cost=3.11..177.31 rows=88 width=8) (actual time=0.147..1.193 rows=312 loops=1)

  • Output: c_68.newid
  • Recheck Cond: (c_68.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_68.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=308
97. 0.101 0.101 ↓ 3.5 312 1

Bitmap Index Scan on coupon_p2019_04_playeridfki (cost=0.00..3.09 rows=88 width=0) (actual time=0.101..0.101 rows=312 loops=1)

  • Index Cond: (c_68.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
98. 0.246 0.266 ↑ 1.1 75 1

Bitmap Heap Scan on coupon.coupon_p2019_05 c_69 (cost=3.05..161.92 rows=80 width=8) (actual time=0.034..0.266 rows=75 loops=1)

  • Output: c_69.newid
  • Recheck Cond: (c_69.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_69.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=75
99. 0.020 0.020 ↑ 1.1 75 1

Bitmap Index Scan on coupon_p2019_05_playeridfki (cost=0.00..3.03 rows=80 width=0) (actual time=0.020..0.020 rows=75 loops=1)

  • Index Cond: (c_69.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
100. 1.311 1.456 ↓ 6.3 387 1

Bitmap Heap Scan on coupon.coupon_p2019_06 c_70 (cost=2.90..123.31 rows=61 width=8) (actual time=0.199..1.456 rows=387 loops=1)

  • Output: c_70.newid
  • Recheck Cond: (c_70.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_70.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=377
101. 0.145 0.145 ↓ 6.3 387 1

Bitmap Index Scan on coupon_p2019_06_playeridfki (cost=0.00..2.89 rows=61 width=0) (actual time=0.145..0.145 rows=387 loops=1)

  • Index Cond: (c_70.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
102. 0.530 0.561 ↓ 2.2 151 1

Bitmap Heap Scan on coupon.coupon_p2019_07 c_71 (cost=2.95..137.12 rows=68 width=8) (actual time=0.073..0.561 rows=151 loops=1)

  • Output: c_71.newid
  • Recheck Cond: (c_71.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_71.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=149
103. 0.031 0.031 ↓ 2.2 151 1

Bitmap Index Scan on coupon_p2019_07_playeridfki (cost=0.00..2.94 rows=68 width=0) (actual time=0.031..0.031 rows=151 loops=1)

  • Index Cond: (c_71.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
104. 2.361 2.636 ↓ 8.3 678 1

Bitmap Heap Scan on coupon.coupon_p2019_08 c_72 (cost=3.07..165.48 rows=82 width=8) (actual time=0.372..2.636 rows=678 loops=1)

  • Output: c_72.newid
  • Recheck Cond: (c_72.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_72.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=661
105. 0.275 0.275 ↓ 8.3 678 1

Bitmap Index Scan on coupon_p2019_08_playeridfki (cost=0.00..3.05 rows=82 width=0) (actual time=0.275..0.275 rows=678 loops=1)

  • Index Cond: (c_72.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
106. 0.326 0.352 ↓ 2.4 97 1

Bitmap Heap Scan on coupon.coupon_p2019_09 c_73 (cost=2.74..83.75 rows=41 width=8) (actual time=0.050..0.352 rows=97 loops=1)

  • Output: c_73.newid
  • Recheck Cond: (c_73.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
  • Filter: (c_73.recorddate >= (CURRENT_DATE - '1 year'::interval))
  • Heap Blocks: exact=92
107. 0.026 0.026 ↓ 2.4 97 1

Bitmap Index Scan on coupon_p2019_09_playeridfki (cost=0.00..2.73 rows=41 width=0) (actual time=0.026..0.026 rows=97 loops=1)

  • Index Cond: (c_73.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid)
108. 11.428 54.283 ↑ 7.0 1 2,857

Append (cost=0.00..21.09 rows=7 width=21) (actual time=0.017..0.019 rows=1 loops=2,857)

109. 0.000 0.000 ↓ 0.0 0 2,857

Seq Scan on coupon.coupontransaction ct (cost=0.00..0.00 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=2,857)

  • Output: ct.actiondate, ct.amount, ct.couponnewid
  • Filter: (c_37.newid = ct.couponnewid)
110. 8.571 8.571 ↓ 0.0 0 2,857

Index Scan using coupontransaction_p2017_couponnewid_uidx on coupon.coupontransaction_p2017 ct_1 (cost=0.44..4.43 rows=1 width=21) (actual time=0.003..0.003 rows=0 loops=2,857)

  • Output: ct_1.actiondate, ct_1.amount, ct_1.couponnewid
  • Index Cond: (ct_1.couponnewid = c_37.newid)
111. 8.571 8.571 ↓ 0.0 0 2,857

Index Scan using coupontransaction_p2010_2016_couponnewid_uidx on coupon.coupontransaction_p2010_2016 ct_2 (cost=0.57..7.81 rows=3 width=21) (actual time=0.003..0.003 rows=0 loops=2,857)

  • Output: ct_2.actiondate, ct_2.amount, ct_2.couponnewid
  • Index Cond: (ct_2.couponnewid = c_37.newid)
112. 8.571 8.571 ↓ 0.0 0 2,857

Index Scan using coupontransaction_p2018_couponnewid_uidx on coupon.coupontransaction_p2018 ct_3 (cost=0.44..4.43 rows=1 width=21) (actual time=0.003..0.003 rows=0 loops=2,857)

  • Output: ct_3.actiondate, ct_3.amount, ct_3.couponnewid
  • Index Cond: (ct_3.couponnewid = c_37.newid)
113. 17.142 17.142 ↑ 1.0 1 2,857

Index Scan using coupontransaction_p2019_couponnewid_uidx on coupon.coupontransaction_p2019 ct_4 (cost=0.43..4.41 rows=1 width=21) (actual time=0.005..0.006 rows=1 loops=2,857)

  • Output: ct_4.actiondate, ct_4.amount, ct_4.couponnewid
  • Index Cond: (ct_4.couponnewid = c_37.newid)
114. 0.429 0.429 ↓ 3.4 184 1

Index Scan using banktransaction_transactionstatus_playerid_lastactiondate_idx on payment.banktransaction bt (cost=0.57..56.56 rows=54 width=53) (actual time=0.032..0.429 rows=184 loops=1)

  • Output: bt.lastactiondate, bt.amount, 'BankTransaction'::text, (bt.instantpaid)::character(1)
  • Index Cond: ((bt.transactionstatus = 'successful'::banktransactionstatus) AND (bt.playerid = '00003135-eed4-4698-a43f-eac2560c5116'::uuid) AND (bt.lastactiondate >= (CURRENT_DATE - '1 year'::interval)))
Planning time : 27.842 ms