explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j267 : with year cutoff

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 38.995 ↑ 1.0 10 1

Limit (cost=5,568.55..5,568.57 rows=10 width=44) (actual time=38.963..38.995 rows=10 loops=1)

  • Buffers: shared hit=43407 read=9
  • I/O Timings: read=2.045
2. 0.197 38.962 ↑ 9.7 10 1

Sort (cost=5,568.55..5,568.79 rows=97 width=44) (actual time=38.962..38.962 rows=10 loops=1)

  • Sort Key: d.created DESC, d.donationid DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=43407 read=9
  • I/O Timings: read=2.045
3. 0.546 38.765 ↓ 12.5 1,210 1

HashAggregate (cost=5,564.51..5,565.48 rows=97 width=44) (actual time=38.601..38.765 rows=1,210 loops=1)

  • Group Key: ('donation'::text), d.donationid, d.created
  • Buffers: shared hit=43401 read=9
  • I/O Timings: read=2.045
4.          

CTE instantfundraisingpromomatchgpsreturnedtograntaccount

5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.49..1,087.83 rows=12 width=4) (never executed)

  • Join Filter: (accountcredit.donorid <> dcproposal_1.createduserid)
6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.06..1,062.20 rows=48 width=12) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.62..255.87 rows=9 width=12) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.19..250.36 rows=9 width=12) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on giftpurchase giftpurchase_3 (cost=4.75..174.17 rows=9 width=12) (never executed)

  • Recheck Cond: (purchasedonorid = 3511331)
  • Filter: (createddate > '2018-12-31 00:00:00'::timestamp without time zone)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on giftpurchase_purchasedonorid (cost=0.00..4.75 rows=43 width=0) (never executed)

  • Index Cond: (purchasedonorid = 3511331)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using giving_cart_item_pkey on giving_cart_item (cost=0.44..8.46 rows=1 width=8) (never executed)

  • Index Cond: (id = giftpurchase_3.cart_item)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_dcproposal on dcproposal dcproposal_1 (cost=0.43..0.60 rows=1 width=8) (never executed)

  • Index Cond: (proposalid = giving_cart_item.intended_project)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using giftcode_altindex1 on giftcode giftcode_3 (cost=0.44..80.89 rows=870 width=8) (never executed)

  • Index Cond: (giftpurchaseid = giftpurchase_3.promomatchgpid)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using accountcredit_giftcodeid on accountcredit (cost=0.43..0.51 rows=2 width=8) (never executed)

  • Index Cond: (giftcodeid = giftcode_3.id)
  • Filter: (credittype = 0)
15.          

CTE instantfundraisinggiftpurchaseandpromomatchids

16. 0.000 0.037 ↓ 0.0 0 1

Unique (cost=433.02..433.03 rows=2 width=4) (actual time=0.037..0.037 rows=0 loops=1)

  • Buffers: shared hit=14
17. 0.006 0.037 ↓ 0.0 0 1

Sort (cost=433.02..433.03 rows=2 width=4) (actual time=0.037..0.037 rows=0 loops=1)

  • Sort Key: giftpurchase_4.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=14
18. 0.002 0.031 ↓ 0.0 0 1

Append (cost=5.19..433.01 rows=2 width=4) (actual time=0.031..0.031 rows=0 loops=1)

  • Buffers: shared hit=14
19. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=5.19..250.36 rows=1 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Buffers: shared hit=9
20. 0.004 0.012 ↑ 9.0 1 1

Bitmap Heap Scan on giftpurchase giftpurchase_4 (cost=4.75..174.17 rows=9 width=8) (actual time=0.012..0.012 rows=1 loops=1)

  • Recheck Cond: (purchasedonorid = 3511331)
  • Filter: (createddate > '2018-12-31 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
21. 0.008 0.008 ↑ 21.5 2 1

Bitmap Index Scan on giftpurchase_purchasedonorid (cost=0.00..4.75 rows=43 width=0) (actual time=0.008..0.008 rows=2 loops=1)

  • Index Cond: (purchasedonorid = 3511331)
  • Buffers: shared hit=3
22. 0.006 0.006 ↓ 0.0 0 1

Index Scan using giving_cart_item_pkey on giving_cart_item giving_cart_item_1 (cost=0.44..8.46 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id = giftpurchase_4.cart_item)
  • Filter: (intended_project IS NOT NULL)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4
23. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=5.19..182.63 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=5
24. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on giftpurchase giftpurchase_5 (cost=4.75..174.17 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (purchasedonorid = 3511331)
  • Filter: ((promomatchgpid IS NOT NULL) AND (createddate > '2018-12-31 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
25. 0.008 0.008 ↑ 21.5 2 1

Bitmap Index Scan on giftpurchase_purchasedonorid (cost=0.00..4.75 rows=43 width=0) (actual time=0.008..0.008 rows=2 loops=1)

  • Index Cond: (purchasedonorid = 3511331)
  • Buffers: shared hit=3
26. 0.000 0.000 ↓ 0.0 0

Index Scan using giving_cart_item_pkey on giving_cart_item giving_cart_item_2 (cost=0.44..8.46 rows=1 width=4) (never executed)

  • Index Cond: (id = giftpurchase_5.cart_item)
  • Filter: (intended_project IS NOT NULL)
27. 0.100 38.219 ↓ 12.5 1,210 1

Append (cost=426.12..4,042.92 rows=97 width=44) (actual time=12.540..38.219 rows=1,210 loops=1)

  • Buffers: shared hit=43401 read=9
  • I/O Timings: read=2.045
28. 0.145 12.763 ↓ 1,204.0 1,204 1

Unique (cost=426.12..426.13 rows=1 width=44) (actual time=12.540..12.763 rows=1,204 loops=1)

  • Buffers: shared hit=10879 read=9
  • I/O Timings: read=2.045
29. 0.419 12.618 ↓ 1,204.0 1,204 1

Sort (cost=426.12..426.12 rows=1 width=44) (actual time=12.539..12.618 rows=1,204 loops=1)

  • Sort Key: d.donationid, d.created
  • Sort Method: quicksort Memory: 143kB
  • Buffers: shared hit=10879 read=9
  • I/O Timings: read=2.045
30. 0.437 12.199 ↓ 1,204.0 1,204 1

Nested Loop Left Join (cost=4.47..426.11 rows=1 width=44) (actual time=1.557..12.199 rows=1,204 loops=1)

  • Filter: ((promoproposal.createduserid IS NULL) OR (promogp.purchasedonorid = 3511331))
  • Buffers: shared hit=10879 read=9
  • I/O Timings: read=2.045
31. 0.404 11.762 ↓ 1,204.0 1,204 1

Nested Loop Left Join (cost=4.04..425.49 rows=1 width=20) (actual time=1.556..11.762 rows=1,204 loops=1)

  • Buffers: shared hit=10879 read=9
  • I/O Timings: read=2.045
32. 0.405 11.358 ↓ 1,204.0 1,204 1

Nested Loop Left Join (cost=3.60..424.65 rows=1 width=20) (actual time=1.555..11.358 rows=1,204 loops=1)

  • Buffers: shared hit=10879 read=9
  • I/O Timings: read=2.045
33. 0.322 10.953 ↓ 1,204.0 1,204 1

Nested Loop Left Join (cost=3.17..424.18 rows=1 width=16) (actual time=1.553..10.953 rows=1,204 loops=1)

  • Filter: ((dcproposal.createduserid IS NULL) OR (giftpurchase.purchasedonorid = 3511331))
  • Buffers: shared hit=10870 read=9
  • I/O Timings: read=2.045
34. 0.278 7.019 ↓ 50.2 1,204 1

Nested Loop Left Join (cost=1.00..274.14 rows=24 width=16) (actual time=1.542..7.019 rows=1,204 loops=1)

  • Buffers: shared hit=5995 read=9
  • I/O Timings: read=2.045
35. 3.129 3.129 ↓ 50.2 1,204 1

Index Scan using dcdonation_donorid_created on dcdonation d (cost=0.56..70.92 rows=24 width=12) (actual time=1.524..3.129 rows=1,204 loops=1)

  • Index Cond: ((donorid = 3511331) AND (created > '2018-12-31 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1167 read=9
  • I/O Timings: read=2.045
36. 3.612 3.612 ↑ 1.0 1 1,204

Index Scan using giving_cart_item_donation on giving_cart_item donationitem (cost=0.44..8.46 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1,204)

  • Index Cond: (donation = d.donationid)
  • Filter: ((type)::text = 'proposal_donation'::text)
  • Buffers: shared hit=4828
37. 0.000 3.612 ↓ 0.0 0 1,204

Nested Loop Left Join (cost=2.17..6.23 rows=2 width=16) (actual time=0.003..0.003 rows=0 loops=1,204)

  • Buffers: shared hit=4875
38. 0.000 3.612 ↓ 0.0 0 1,204

Nested Loop Left Join (cost=1.74..5.00 rows=2 width=16) (actual time=0.003..0.003 rows=0 loops=1,204)

  • Buffers: shared hit=4875
39. 0.000 3.612 ↓ 0.0 0 1,204

Nested Loop Left Join (cost=1.30..3.31 rows=2 width=16) (actual time=0.003..0.003 rows=0 loops=1,204)

  • Buffers: shared hit=4875
40. 1.189 3.612 ↓ 0.0 0 1,204

Nested Loop Left Join (cost=0.88..2.36 rows=2 width=8) (actual time=0.003..0.003 rows=0 loops=1,204)

  • Buffers: shared hit=4863
41. 2.408 2.408 ↓ 0.0 0 1,204

Index Scan using giving_cart_item_cart on giving_cart_item redemptionitem (cost=0.44..0.77 rows=2 width=8) (actual time=0.002..0.002 rows=0 loops=1,204)

  • Index Cond: (cart = donationitem.cart)
  • Filter: ((type)::text = 'gc_redemption'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4851
42. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pk_giftcode on giftcode (cost=0.44..0.79 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (id = redemptionitem.gift_code)
  • Buffers: shared hit=12
43. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pk_giftpurchase on giftpurchase (cost=0.43..0.46 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (id = giftcode.giftpurchaseid)
  • Buffers: shared hit=12
44. 0.000 0.000 ↓ 0.0 0 3

Index Scan using giving_cart_item_pkey on giving_cart_item gpitem (cost=0.44..0.83 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=3)

  • Index Cond: (id = giftpurchase.cart_item)
45. 0.000 0.000 ↓ 0.0 0 3

Index Scan using pk_dcproposal on dcproposal (cost=0.43..0.60 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=3)

  • Index Cond: (gpitem.intended_project = proposalid)
  • Filter: (createduserid = 3511331)
46. 0.000 0.000 ↓ 0.0 0 1,204

Index Scan using uix_giftpurchase_promomatchgpid on giftpurchase promogp (cost=0.43..0.46 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=1,204)

  • Index Cond: (promomatchgpid = giftcode.giftpurchaseid)
  • Buffers: shared hit=9
47. 0.000 0.000 ↓ 0.0 0 1,204

Index Scan using giving_cart_item_pkey on giving_cart_item promoitem (cost=0.44..0.83 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,204)

  • Index Cond: (id = promogp.cart_item)
48. 0.000 0.000 ↓ 0.0 0 1,204

Index Scan using pk_dcproposal on dcproposal promoproposal (cost=0.43..0.60 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,204)

  • Index Cond: (promoitem.intended_project = proposalid)
  • Filter: (createduserid = 3511331)
49. 0.003 0.126 ↑ 8.6 5 1

Unique (cost=616.26..616.58 rows=43 width=44) (actual time=0.124..0.126 rows=5 loops=1)

  • Buffers: shared hit=34
50. 0.011 0.123 ↑ 8.6 5 1

Sort (cost=616.26..616.37 rows=43 width=44) (actual time=0.122..0.123 rows=5 loops=1)

  • Sort Key: donationitem_1.donation, donationitem_1.create_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=34
51. 0.002 0.112 ↑ 8.6 5 1

Nested Loop (cost=6.11..615.10 rows=43 width=44) (actual time=0.107..0.112 rows=5 loops=1)

  • Buffers: shared hit=34
52. 0.001 0.099 ↑ 4.0 1 1

Nested Loop (cost=5.67..610.65 rows=4 width=4) (actual time=0.098..0.099 rows=1 loops=1)

  • Buffers: shared hit=27
53. 0.003 0.088 ↑ 21.0 1 1

Nested Loop (cost=5.24..533.19 rows=21 width=4) (actual time=0.087..0.088 rows=1 loops=1)

  • Buffers: shared hit=23
54. 0.025 0.080 ↑ 4.0 1 1

Bitmap Heap Scan on giftpurchase giftpurchase_1 (cost=4.80..174.32 rows=4 width=4) (actual time=0.080..0.080 rows=1 loops=1)

  • Recheck Cond: (purchasedonorid = 3511331)
  • Filter: ((sponsorgiftpurchaseid IS NULL) AND (createddate > '2018-12-31 00:00:00'::timestamp without time zone) AND (NOT (hashed SubPlan 8)))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=2
  • Buffers: shared hit=19
55. 0.016 0.016 ↑ 21.5 2 1

Bitmap Index Scan on giftpurchase_purchasedonorid (cost=0.00..4.75 rows=43 width=0) (actual time=0.015..0.016 rows=2 loops=1)

  • Index Cond: (purchasedonorid = 3511331)
  • Buffers: shared hit=3
56.          

SubPlan (for Bitmap Heap Scan)

57. 0.039 0.039 ↓ 0.0 0 1

CTE Scan on instantfundraisinggiftpurchaseandpromomatchids instantfundraisinggiftpurchaseandpromomatchids_1 (cost=0.00..0.04 rows=2 width=4) (actual time=0.039..0.039 rows=0 loops=1)

  • Buffers: shared hit=14
58. 0.005 0.005 ↑ 870.0 1 1

Index Scan using giftcode_altindex1 on giftcode giftcode_1 (cost=0.44..81.02 rows=870 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (giftpurchaseid = giftpurchase_1.id)
  • Buffers: shared hit=4
59. 0.010 0.010 ↑ 30.0 1 1

Index Scan using giving_cart_item_gift_code on giving_cart_item redemptionitem_1 (cost=0.44..3.39 rows=30 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (gift_code = giftcode_1.id)
  • Filter: ((type)::text = 'gc_redemption'::text)
  • Buffers: shared hit=4
60. 0.011 0.011 ↑ 1.2 5 1

Index Scan using giving_cart_item_cart on giving_cart_item donationitem_1 (cost=0.44..1.05 rows=6 width=16) (actual time=0.007..0.011 rows=5 loops=1)

  • Index Cond: (cart = redemptionitem_1.cart)
  • Filter: ((type)::text = 'proposal_donation'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=7
61. 0.000 0.037 ↓ 0.0 0 1

Unique (cost=649.48..649.80 rows=43 width=44) (actual time=0.037..0.037 rows=0 loops=1)

  • Buffers: shared hit=5
62. 0.007 0.037 ↓ 0.0 0 1

Sort (cost=649.48..649.59 rows=43 width=44) (actual time=0.037..0.037 rows=0 loops=1)

  • Sort Key: donationitem_2.donation, donationitem_2.create_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=5
63. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=6.39..648.32 rows=43 width=44) (actual time=0.030..0.030 rows=0 loops=1)

  • Buffers: shared hit=5
64. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=5.95..643.87 rows=4 width=4) (actual time=0.030..0.030 rows=0 loops=1)

  • Buffers: shared hit=5
65. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=5.51..566.41 rows=21 width=4) (actual time=0.030..0.030 rows=0 loops=1)

  • Buffers: shared hit=5
66. 0.004 0.030 ↓ 0.0 0 1

Nested Loop (cost=5.08..207.54 rows=4 width=4) (actual time=0.030..0.030 rows=0 loops=1)

  • Buffers: shared hit=5
67. 0.021 0.026 ↑ 4.0 1 1

Bitmap Heap Scan on giftpurchase giftpurchase_2 (cost=4.80..174.32 rows=4 width=8) (actual time=0.025..0.026 rows=1 loops=1)

  • Recheck Cond: (purchasedonorid = 3511331)
  • Filter: ((createddate > '2018-12-31 00:00:00'::timestamp without time zone) AND (NOT (hashed SubPlan 7)))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
68. 0.005 0.005 ↑ 21.5 2 1

Bitmap Index Scan on giftpurchase_purchasedonorid (cost=0.00..4.75 rows=43 width=0) (actual time=0.005..0.005 rows=2 loops=1)

  • Index Cond: (purchasedonorid = 3511331)
  • Buffers: shared hit=3
69.          

SubPlan (for Bitmap Heap Scan)

70. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on instantfundraisinggiftpurchaseandpromomatchids (cost=0.00..0.04 rows=2 width=4) (actual time=0.000..0.000 rows=0 loops=1)

71. 0.000 0.000 ↓ 0.0 0 1

Index Only Scan using matching_pkey on matching (cost=0.28..8.29 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (matchingid = giftpurchase_2.sponsormatchingid)
  • Heap Fetches: 0
72. 0.000 0.000 ↓ 0.0 0

Index Scan using giftcode_altindex1 on giftcode giftcode_2 (cost=0.44..81.02 rows=870 width=8) (never executed)

  • Index Cond: (giftpurchaseid = giftpurchase_2.id)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using giving_cart_item_gift_code on giving_cart_item redemptionitem_2 (cost=0.44..3.39 rows=30 width=8) (never executed)

  • Index Cond: (gift_code = giftcode_2.id)
  • Filter: ((type)::text = 'gc_redemption'::text)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using giving_cart_item_cart on giving_cart_item donationitem_2 (cost=0.44..1.05 rows=6 width=16) (never executed)

  • Index Cond: (cart = redemptionitem_2.cart)
  • Filter: ((type)::text = 'proposal_donation'::text)
75. 0.000 0.041 ↓ 0.0 0 1

Nested Loop (cost=175.34..418.94 rows=7 width=44) (actual time=0.041..0.041 rows=0 loops=1)

  • Buffers: shared hit=13
76.          

Initplan (for Nested Loop)

77. 0.010 0.020 ↑ 1.0 1 1

Aggregate (cost=174.19..174.20 rows=1 width=32) (actual time=0.020..0.020 rows=1 loops=1)

  • Buffers: shared hit=5
78. 0.004 0.010 ↑ 9.0 1 1

Bitmap Heap Scan on giftpurchase gp_3 (cost=4.75..174.17 rows=9 width=4) (actual time=0.010..0.010 rows=1 loops=1)

  • Recheck Cond: (purchasedonorid = 3511331)
  • Filter: (createddate > '2018-12-31 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
79. 0.006 0.006 ↑ 21.5 2 1

Bitmap Index Scan on giftpurchase_purchasedonorid (cost=0.00..4.75 rows=43 width=0) (actual time=0.006..0.006 rows=2 loops=1)

  • Index Cond: (purchasedonorid = 3511331)
  • Buffers: shared hit=3
80. 0.034 0.034 ↑ 22.0 1 1

Index Scan using payment_altindex2 on payment (cost=0.44..52.57 rows=22 width=4) (actual time=0.033..0.034 rows=1 loops=1)

  • Index Cond: (giftpurchaseid = ANY ($10))
  • Filter: ((paymenttype)::text <> 'debit'::text)
  • Buffers: shared hit=9
81. 0.004 0.004 ↓ 0.0 0 1

Index Scan using pk_giftpurchase on giftpurchase gp (cost=0.70..8.72 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (id = payment.giftpurchaseid)
  • Filter: ((cart_item IS NULL) AND (credittype <> 3) AND (amount > '0'::numeric) AND (NOT (hashed SubPlan 6)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4
82.          

SubPlan (for Index Scan)

83. 0.000 0.000 ↓ 0.0 0

CTE Scan on instantfundraisingpromomatchgpsreturnedtograntaccount instantfundraisingpromomatchgpsreturnedtograntaccount_1 (cost=0.00..0.24 rows=12 width=4) (never executed)

84. 0.000 0.052 ↓ 0.0 0 1

Nested Loop (cost=175.33..541.31 rows=1 width=44) (actual time=0.052..0.052 rows=0 loops=1)

  • Buffers: shared hit=20
85.          

Initplan (for Nested Loop)

86. 0.007 0.015 ↑ 1.0 1 1

Aggregate (cost=174.18..174.19 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=1)

  • Buffers: shared hit=5
87. 0.002 0.008 ↑ 21.5 2 1

Bitmap Heap Scan on giftpurchase gp_2 (cost=4.76..174.07 rows=43 width=4) (actual time=0.006..0.008 rows=2 loops=1)

  • Recheck Cond: (purchasedonorid = 3511331)
  • Heap Blocks: exact=2
  • Buffers: shared hit=5
88. 0.006 0.006 ↑ 21.5 2 1

Bitmap Index Scan on giftpurchase_purchasedonorid (cost=0.00..4.75 rows=43 width=0) (actual time=0.006..0.006 rows=2 loops=1)

  • Index Cond: (purchasedonorid = 3511331)
  • Buffers: shared hit=3
89. 0.046 0.046 ↑ 36.0 1 1

Index Scan using payment_altindex2 on payment payment_1 (cost=0.44..52.57 rows=36 width=4) (actual time=0.044..0.046 rows=1 loops=1)

  • Index Cond: (giftpurchaseid = ANY ($8))
  • Filter: ((paymenttype)::text = 'debit'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=16
90. 0.005 0.005 ↓ 0.0 0 1

Index Scan using pk_giftpurchase on giftpurchase gp_1 (cost=0.70..8.73 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id = payment_1.giftpurchaseid)
  • Filter: ((cart_item IS NULL) AND (sponsormatchingid IS NOT NULL) AND (createddate > '2018-12-31 00:00:00'::timestamp without time zone) AND (credittype <> 3) AND (amount > '0'::numeric) AND (NOT (hashed SubPlan 4)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4
91.          

SubPlan (for Index Scan)

92. 0.000 0.000 ↓ 0.0 0

CTE Scan on instantfundraisingpromomatchgpsreturnedtograntaccount (cost=0.00..0.24 rows=12 width=4) (never executed)

93. 0.137 12.600 ↑ 1.0 1 1

Nested Loop (cost=0.87..694.59 rows=1 width=44) (actual time=12.442..12.600 rows=1 loops=1)

  • Buffers: shared hit=16225
94. 2.605 2.605 ↓ 51.3 3,286 1

Index Scan using giving_cart_donor on giving_cart gc (cost=0.43..116.92 rows=64 width=4) (actual time=0.011..2.605 rows=3,286 loops=1)

  • Index Cond: (donor = 3511331)
  • Buffers: shared hit=3021
95. 9.858 9.858 ↓ 0.0 0 3,286

Index Scan using giving_cart_item_cart on giving_cart_item gci (cost=0.44..9.02 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=3,286)

  • Index Cond: (cart = gc.id)
  • Filter: ((create_date > '2018-12-31 00:00:00'::timestamp without time zone) AND ((type)::text = 'gc_purchase'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=13204
96. 0.084 12.500 ↓ 0.0 0 1

Nested Loop (cost=0.87..694.59 rows=1 width=44) (actual time=12.499..12.500 rows=0 loops=1)

  • Buffers: shared hit=16225
97. 2.558 2.558 ↓ 51.3 3,286 1

Index Scan using giving_cart_donor on giving_cart gc_1 (cost=0.43..116.92 rows=64 width=4) (actual time=0.010..2.558 rows=3,286 loops=1)

  • Index Cond: (donor = 3511331)
  • Buffers: shared hit=3021
98. 9.858 9.858 ↓ 0.0 0 3,286

Index Scan using giving_cart_item_cart on giving_cart_item gci_1 (cost=0.44..9.02 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=3,286)

  • Index Cond: (cart = gc_1.id)
  • Filter: ((create_date > '2018-12-31 00:00:00'::timestamp without time zone) AND ((type)::text = 'account_credit_purchase'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=13204
Planning time : 8.520 ms
Execution time : 40.023 ms