explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v8On

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 11,451.420 ↓ 4.0 4 1

Sort (cost=55,618.89..55,618.89 rows=1 width=1,198) (actual time=11,451.418..11,451.420 rows=4 loops=1)

  • Sort Key: c.customername
  • Sort Method: quicksort Memory: 27kB
2.          

CTE validcustomers

3. 4.476 140.351 ↓ 44.0 25,280 1

Group (cost=4,943.64..4,947.95 rows=574 width=16) (actual time=132.876..140.351 rows=25,280 loops=1)

  • Group Key: c_1.customerid, a.salesforceid
4. 11.080 135.875 ↓ 44.0 25,280 1

Sort (cost=4,943.64..4,945.08 rows=574 width=16) (actual time=132.874..135.875 rows=25,280 loops=1)

  • Sort Key: c_1.customerid
  • Sort Method: quicksort Memory: 1,954kB
5. 14.829 124.795 ↓ 44.0 25,280 1

Nested Loop (cost=61.07..4,917.34 rows=574 width=16) (actual time=8.664..124.795 rows=25,280 loops=1)

6. 2.456 33.901 ↓ 39.9 25,355 1

Nested Loop (cost=60.64..4,464.07 rows=636 width=16) (actual time=8.650..33.901 rows=25,355 loops=1)

7. 0.002 0.026 ↑ 1.0 1 1

Nested Loop (cost=0.56..16.62 rows=1 width=16) (actual time=0.024..0.026 rows=1 loops=1)

8. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using oisocv_userid_salesforceid_orgunitid_idx on orgunitidsfromuserspanofcontrol_view y (cost=0.28..8.30 rows=1 width=16) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((userid = 9,046) AND (salesforceid = 268))
  • Heap Fetches: 1
9. 0.010 0.010 ↑ 1.0 1 1

Index Scan using pk_users_userid on users u (cost=0.28..8.30 rows=1 width=0) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (userid = 9,046)
  • Filter: (isdeleted = 0)
10. 25.822 31.419 ↓ 22.7 25,355 1

Bitmap Heap Scan on alignments a (cost=60.07..4,436.29 rows=1,116 width=24) (actual time=8.622..31.419 rows=25,355 loops=1)

  • Recheck Cond: ((salesforceid = 268) AND (orgunitid = y.orgunitid))
  • Filter: (isdeleted = 0)
  • Heap Blocks: exact=17,397
11. 5.597 5.597 ↓ 22.6 25,355 1

Bitmap Index Scan on alignments_salesforceid_orgunitid_customerid_idx (cost=0.00..59.80 rows=1,123 width=0) (actual time=5.597..5.597 rows=25,355 loops=1)

  • Index Cond: ((salesforceid = 268) AND (orgunitid = y.orgunitid))
12. 76.065 76.065 ↑ 1.0 1 25,355

Index Scan using pk_customers_customerid on customers c_1 (cost=0.43..0.70 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=25,355)

  • Index Cond: (customerid = a.customerid)
  • Filter: (isdeleted = 0)
13.          

CTE hvhc

14. 0.007 9.025 ↓ 30.0 30 1

Group (cost=48.21..48.21 rows=1 width=12) (actual time=9.017..9.025 rows=30 loops=1)

  • Group Key: c_2.customerid
15. 0.017 9.018 ↓ 32.0 32 1

Sort (cost=48.21..48.21 rows=1 width=8) (actual time=9.016..9.018 rows=32 loops=1)

  • Sort Key: c_2.customerid
  • Sort Method: quicksort Memory: 26kB
16. 0.029 9.001 ↓ 32.0 32 1

Nested Loop (cost=13.23..48.20 rows=1 width=8) (actual time=4.395..9.001 rows=32 loops=1)

  • Join Filter: (cs.segmentvalueid = sv.segmentvalueid)
17. 0.008 8.940 ↓ 32.0 32 1

Nested Loop (cost=13.08..43.22 rows=1 width=24) (actual time=4.382..8.940 rows=32 loops=1)

18. 0.023 8.864 ↓ 34.0 34 1

Nested Loop (cost=8.89..30.53 rows=1 width=16) (actual time=4.370..8.864 rows=34 loops=1)

19. 2.489 8.739 ↓ 34.0 34 1

Hash Join (cost=8.46..22.11 rows=1 width=24) (actual time=4.354..8.739 rows=34 loops=1)

  • Hash Cond: (validcustomers_1.customerid = cs.customerid)
20. 1.906 1.906 ↓ 44.0 25,280 1

CTE Scan on validcustomers validcustomers_1 (cost=0.00..11.48 rows=574 width=8) (actual time=0.001..1.906 rows=25,280 loops=1)

21. 1.475 4.344 ↓ 9,212.0 9,212 1

Hash (cost=8.45..8.45 rows=1 width=16) (actual time=4.344..4.344 rows=9,212 loops=1)

  • Buckets: 16,384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 560kB
22. 2.869 2.869 ↓ 9,245.0 9,245 1

Index Scan using customersegment_productid_idx on customersegment cs (cost=0.43..8.45 rows=1 width=16) (actual time=0.035..2.869 rows=9,245 loops=1)

  • Index Cond: (productid IS NULL)
  • Filter: (isdeleted = 0)
23. 0.102 0.102 ↑ 1.0 1 34

Index Scan using pk_customers_customerid on customers c_2 (cost=0.43..8.42 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=34)

  • Index Cond: (customerid = validcustomers_1.customerid)
  • Filter: (isdeleted = 0)
24. 0.034 0.068 ↑ 1.0 1 34

Bitmap Heap Scan on highvaluehcpconfiguration hvhc_1 (cost=4.19..12.68 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=34)

  • Recheck Cond: (segmentvalueid = cs.segmentvalueid)
  • Filter: (isdeleted = 0)
  • Heap Blocks: exact=32
25. 0.034 0.034 ↑ 2.5 2 34

Bitmap Index Scan on highvaluehcpconfiguration_segmentvalueid_idx (cost=0.00..4.19 rows=5 width=0) (actual time=0.001..0.001 rows=2 loops=34)

  • Index Cond: (segmentvalueid = cs.segmentvalueid)
26. 0.032 0.032 ↑ 1.0 1 32

Index Scan using pk_segmentvalueid on segmentvalue sv (cost=0.15..4.97 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=32)

  • Index Cond: (segmentvalueid = hvhc_1.segmentvalueid)
  • Filter: (isdeleted = 0)
27.          

CTE temp1

28. 0.077 17.115 ↓ 24.5 98 1

GroupAggregate (cost=7,181.55..7,181.63 rows=4 width=44) (actual time=17.012..17.115 rows=98 loops=1)

  • Group Key: c_3.customerid
29. 0.117 17.038 ↓ 75.0 300 1

Sort (cost=7,181.55..7,181.56 rows=4 width=16) (actual time=17.003..17.038 rows=300 loops=1)

  • Sort Key: c_3.customerid
  • Sort Method: quicksort Memory: 39kB
30. 0.237 16.921 ↓ 75.0 300 1

Nested Loop Left Join (cost=33.89..7,181.51 rows=4 width=16) (actual time=6.559..16.921 rows=300 loops=1)

31. 0.155 16.084 ↓ 75.0 300 1

Nested Loop Left Join (cost=33.47..7,178.90 rows=4 width=16) (actual time=6.547..16.084 rows=300 loops=1)

32. 0.260 15.029 ↓ 75.0 300 1

Nested Loop (cost=33.05..7,176.89 rows=4 width=24) (actual time=6.535..15.029 rows=300 loops=1)

  • Join Filter: (validcustomers_2.customerid = c_3.customerid)
33. 0.439 14.169 ↓ 75.0 300 1

Nested Loop (cost=32.62..7,175.01 rows=4 width=32) (actual time=6.519..14.169 rows=300 loops=1)

  • Join Filter: (uipreference_1.insightid = insights_1.insightid)
34. 0.288 11.030 ↓ 64.3 900 1

Hash Join (cost=32.19..7,167.63 rows=14 width=40) (actual time=6.473..11.030 rows=900 loops=1)

  • Hash Cond: (ia_1.entityid = validcustomers_2.customerid)
35. 0.148 4.526 ↓ 2.8 1,200 1

Nested Loop (cost=13.53..7,117.71 rows=422 width=32) (actual time=0.245..4.526 rows=1,200 loops=1)

36. 0.027 0.027 ↑ 1.0 1 1

Seq Scan on entitytypes et_1 (cost=0.00..1.10 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=1)

  • Filter: ((isdeleted = 0) AND (lower(type) = 'customer'::text))
  • Rows Removed by Filter: 4
37. 0.509 4.351 ↓ 2.0 1,200 1

Nested Loop (cost=13.53..7,110.75 rows=586 width=40) (actual time=0.213..4.351 rows=1,200 loops=1)

38. 0.716 0.842 ↓ 1.0 600 1

Bitmap Heap Scan on userinsightpreference uipreference_1 (cost=12.97..2,075.54 rows=586 width=16) (actual time=0.197..0.842 rows=600 loops=1)

  • Recheck Cond: (userid = 9,046)
  • Filter: (status = ANY ('{0,2}'::bigint[]))
  • Heap Blocks: exact=568
39. 0.126 0.126 ↓ 1.0 600 1

Bitmap Index Scan on userinsightpreference_userid_idx (cost=0.00..12.82 rows=586 width=0) (actual time=0.126..0.126 rows=600 loops=1)

  • Index Cond: (userid = 9,046)
40. 3.000 3.000 ↓ 2.0 2 600

Index Scan using unique_insightid_entitytype_and_entityid on insightassociations ia_1 (cost=0.56..8.58 rows=1 width=24) (actual time=0.004..0.005 rows=2 loops=600)

  • Index Cond: ((insightid = uipreference_1.insightid) AND (entitytypeid = et_1.entitytypeid))
  • Filter: (isdeleted = 0)
41. 3.534 6.216 ↓ 44.0 25,280 1

Hash (cost=11.48..11.48 rows=574 width=8) (actual time=6.216..6.216 rows=25,280 loops=1)

  • Buckets: 32,768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1,244kB
42. 2.682 2.682 ↓ 44.0 25,280 1

CTE Scan on validcustomers validcustomers_2 (cost=0.00..11.48 rows=574 width=8) (actual time=0.000..2.682 rows=25,280 loops=1)

43. 2.700 2.700 ↓ 0.0 0 900

Index Scan using pk_insights_insightid on insights insights_1 (cost=0.43..0.51 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=900)

  • Index Cond: (insightid = ia_1.insightid)
  • Filter: ((isdeleted = 0) AND (insighttype = 1) AND (expirydate >= now()))
  • Rows Removed by Filter: 1
44. 0.600 0.600 ↑ 1.0 1 300

Index Only Scan using pk_customers_customerid on customers c_3 (cost=0.43..0.46 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=300)

  • Index Cond: (customerid = ia_1.entityid)
  • Heap Fetches: 300
45. 0.900 0.900 ↑ 1.0 1 300

Index Scan using suggestioninsightmapping_insightid_idx on suggestioninsightmapping sim (cost=0.42..0.49 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=300)

  • Index Cond: (insightid = insights_1.insightid)
  • Filter: (isdeleted = 0)
46. 0.600 0.600 ↑ 1.0 1 300

Index Scan using pk_suggestion_suggestionid on suggestion s (cost=0.42..0.64 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=300)

  • Index Cond: (suggestionid = sim.suggestionid)
  • Filter: (isdeleted = 0)
47.          

CTE temp2

48. 0.016 133.706 ↑ 3.9 35 1

Unique (cost=33,829.18..33,831.04 rows=135 width=52) (actual time=133.680..133.706 rows=35 loops=1)

49. 0.082 133.690 ↑ 2.1 179 1

Sort (cost=33,829.18..33,830.11 rows=372 width=52) (actual time=133.679..133.690 rows=179 loops=1)

  • Sort Key: p.customerid, p.enddate, p.scheduletype
  • Sort Method: quicksort Memory: 45kB
50. 0.115 133.608 ↑ 2.1 179 1

Hash Join (cost=32,972.04..33,813.30 rows=372 width=52) (actual time=133.352..133.608 rows=179 loops=1)

  • Hash Cond: (validcustomers_3.customerid = pc.customerid)
51. 0.051 17.289 ↓ 19.9 179 1

Hash Join (cost=25.34..853.56 rows=9 width=52) (actual time=17.075..17.289 rows=179 loops=1)

  • Hash Cond: (p.customerid = validcustomers_3.customerid)
52. 0.200 0.265 ↓ 1.3 179 1

Bitmap Heap Scan on plannedcalls p (cost=6.69..824.79 rows=136 width=44) (actual time=0.089..0.265 rows=179 loops=1)

  • Recheck Cond: (userid = 9,046)
  • Filter: ((isdeleted = 0) AND ((schedulestatus = 2) OR (((startdate > now()) OR (enddate > now())) AND (enddate >= startdate))))
  • Rows Removed by Filter: 140
  • Heap Blocks: exact=94
53. 0.065 0.065 ↓ 1.4 418 1

Bitmap Index Scan on plannedcalls_userid_idx (cost=0.00..6.65 rows=298 width=0) (actual time=0.065..0.065 rows=418 loops=1)

  • Index Cond: (userid = 9,046)
54. 3.424 16.973 ↓ 44.0 25,280 1

Hash (cost=11.48..11.48 rows=574 width=8) (actual time=16.973..16.973 rows=25,280 loops=1)

  • Buckets: 32,768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1,244kB
55. 13.549 13.549 ↓ 44.0 25,280 1

CTE Scan on validcustomers validcustomers_3 (cost=0.00..11.48 rows=574 width=8) (actual time=0.000..13.549 rows=25,280 loops=1)

56. 1.319 116.204 ↓ 1.0 8,339 1

Hash (cost=32,843.27..32,843.27 rows=8,274 width=16) (actual time=116.204..116.204 rows=8,339 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 519kB
57. 30.928 114.885 ↓ 1.0 8,339 1

HashAggregate (cost=32,677.79..32,760.53 rows=8,274 width=16) (actual time=113.661..114.885 rows=8,339 loops=1)

  • Group Key: pc.customerid
58. 52.556 83.957 ↑ 3.4 148,494 1

Nested Loop (cost=0.00..30,150.94 rows=505,369 width=8) (actual time=0.030..83.957 rows=148,494 loops=1)

  • Join Filter: ((pc.schedulestatus = 2) OR ((pc.schedulestatus = 1) AND (((pc.startdate >= refresh_cycles_view.generateddate) AND (pc.startdate <= refresh_cycles_view.expirydate)) OR ((pc.enddate >= refresh_cycles_view.generateddate) AND (pc.enddate <= refresh_cycles_view.expirydate)))))
  • Rows Removed by Join Filter: 31
59. 31.401 31.401 ↓ 1.3 148,525 1

Seq Scan on plannedcalls pc (cost=0.00..4,676.10 rows=115,660 width=28) (actual time=0.012..31.401 rows=148,525 loops=1)

  • Filter: ((isdeleted = 0) AND ((schedulestatus = 2) OR (schedulestatus = 1)))
  • Rows Removed by Filter: 1
60. 0.000 0.000 ↑ 8.0 1 148,525

Materialize (cost=0.00..29.66 rows=8 width=16) (actual time=0.000..0.000 rows=1 loops=148,525)

61. 0.008 0.008 ↑ 8.0 1 1

Seq Scan on refresh_cycles_view (cost=0.00..29.62 rows=8 width=16) (actual time=0.006..0.008 rows=1 loops=1)

  • Filter: (rank = 1)
  • Rows Removed by Filter: 20
62. 0.015 11,451.393 ↓ 4.0 4 1

Group (cost=9,609.99..9,610.04 rows=1 width=1,198) (actual time=11,451.379..11,451.393 rows=4 loops=1)

  • Group Key: temp2.startdate, temp2.enddate, temp2.timeframe, temp2.schedulestatus, c.customerid, et.entitytypeid, temp2.scheduletype, temp2.plannedcallid, temp2.plannedvisits, temp2.customerid, speciality.specialityname, temp1.suggestedvisitstemp, temp1.ishcprecommended, hvhc.highvalue, lct.displayname, ct.customertype, validcustomers.salesforceid
63. 0.055 11,451.378 ↓ 18.0 18 1

Sort (cost=9,609.99..9,610.00 rows=1 width=1,162) (actual time=11,451.376..11,451.378 rows=18 loops=1)

  • Sort Key: temp2.startdate, temp2.enddate, temp2.timeframe, temp2.schedulestatus, c.customerid, et.entitytypeid, temp2.scheduletype, temp2.plannedcallid, temp2.plannedvisits, temp2.customerid, speciality.specialityname, temp1.suggestedvisitstemp, temp1.ishcprecommended, hvhc.highvalue, lct.displayname, ct.customertype, validcustomers.salesforceid
  • Sort Method: quicksort Memory: 34kB
64. 0.505 11,451.323 ↓ 18.0 18 1

Nested Loop (cost=2,114.39..9,609.98 rows=1 width=1,162) (actual time=296.888..11,451.323 rows=18 loops=1)

  • Join Filter: (insights.generateddate = rf.generateddate)
  • Rows Removed by Join Filter: 882
65. 0.665 11,449.018 ↓ 900.0 900 1

Nested Loop (cost=2,114.39..9,582.22 rows=1 width=1,170) (actual time=293.728..11,449.018 rows=900 loops=1)

66. 0.121 11,447.453 ↓ 900.0 900 1

Nested Loop Left Join (cost=2,114.26..9,582.06 rows=1 width=1,170) (actual time=293.717..11,447.453 rows=900 loops=1)

67. 6,476.413 11,445.532 ↓ 900.0 900 1

Nested Loop (cost=2,114.11..9,575.21 rows=1 width=1,146) (actual time=293.704..11,445.532 rows=900 loops=1)

  • Join Filter: (ia.entityid = c.customerid)
  • Rows Removed by Join Filter: 91,007,100
68. 26.730 1,050.719 ↓ 44.0 25,280 1

Nested Loop Left Join (cost=5.28..5,269.46 rows=574 width=1,138) (actual time=292.761..1,050.719 rows=25,280 loops=1)

  • Join Filter: (ct.customertypeid = c.customertypeid)
  • Rows Removed by Join Filter: 50,560
69. 51.922 1,023.989 ↓ 44.0 25,280 1

Nested Loop Left Join (cost=5.28..5,225.50 rows=574 width=1,098) (actual time=292.748..1,023.989 rows=25,280 loops=1)

  • Join Filter: (speciality.specialityid = csm.specialityid)
  • Rows Removed by Join Filter: 455,100
70. 206.126 946.787 ↓ 44.0 25,280 1

Nested Loop Left Join (cost=5.28..5,215.65 rows=574 width=1,074) (actual time=292.735..946.787 rows=25,280 loops=1)

  • Join Filter: (c.customerid = temp1.customerid)
  • Rows Removed by Join Filter: 2,477,342
71. 8.569 538.421 ↓ 44.0 25,280 1

Nested Loop Left Join (cost=5.28..5,163.95 rows=574 width=1,038) (actual time=275.716..538.421 rows=25,280 loops=1)

72. 11.053 428.732 ↓ 44.0 25,280 1

Hash Left Join (cost=4.85..4,856.27 rows=574 width=1,030) (actual time=275.701..428.732 rows=25,280 loops=1)

  • Hash Cond: (c.customerid = hvhc.customerid)
73. 10.916 408.636 ↓ 44.0 25,280 1

Hash Left Join (cost=4.82..4,854.07 rows=574 width=1,026) (actual time=266.642..408.636 rows=25,280 loops=1)

  • Hash Cond: (c.customerid = temp2.customerid)
74. 23.738 263.993 ↓ 44.0 25,280 1

Nested Loop (cost=0.43..4,847.52 rows=574 width=974) (actual time=132.900..263.993 rows=25,280 loops=1)

75. 139.135 139.135 ↓ 44.0 25,280 1

CTE Scan on validcustomers (cost=0.00..11.48 rows=574 width=16) (actual time=132.877..139.135 rows=25,280 loops=1)

76. 101.120 101.120 ↑ 1.0 1 25,280

Index Scan using pk_customers_customerid on customers c (cost=0.43..8.42 rows=1 width=958) (actual time=0.004..0.004 rows=1 loops=25,280)

  • Index Cond: (customerid = validcustomers.customerid)
  • Filter: ((isdeleted = 0) OR (isdeleted IS NULL))
77. 0.009 133.727 ↑ 3.9 35 1

Hash (cost=2.70..2.70 rows=135 width=52) (actual time=133.727..133.727 rows=35 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
78. 133.718 133.718 ↑ 3.9 35 1

CTE Scan on temp2 (cost=0.00..2.70 rows=135 width=52) (actual time=133.682..133.718 rows=35 loops=1)

79. 0.007 9.043 ↓ 30.0 30 1

Hash (cost=0.02..0.02 rows=1 width=12) (actual time=9.043..9.043 rows=30 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
80. 9.036 9.036 ↓ 30.0 30 1

CTE Scan on hvhc (cost=0.00..0.02 rows=1 width=12) (actual time=9.021..9.036 rows=30 loops=1)

81. 101.120 101.120 ↑ 1.0 1 25,280

Index Scan using customerspecialitymapping_customerid_idx on customerspecialitymapping csm (cost=0.43..0.53 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=25,280)

  • Index Cond: (customerid = c.customerid)
  • Filter: (isprimary AND (isdeleted = 0))
82. 202.240 202.240 ↓ 24.5 98 25,280

CTE Scan on temp1 (cost=0.00..0.08 rows=4 width=44) (actual time=0.001..0.008 rows=98 loops=25,280)

83. 25.271 25.280 ↓ 19.0 19 25,280

Materialize (cost=0.00..1.24 rows=1 width=40) (actual time=0.000..0.001 rows=19 loops=25,280)

84. 0.009 0.009 ↓ 19.0 19 1

Seq Scan on speciality (cost=0.00..1.24 rows=1 width=40) (actual time=0.007..0.009 rows=19 loops=1)

  • Filter: (isdeleted = 0)
85. 0.000 0.000 ↑ 1.0 3 25,280

Materialize (cost=0.00..18.14 rows=3 width=40) (actual time=0.000..0.000 rows=3 loops=25,280)

86. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on customertype ct (cost=0.00..18.12 rows=3 width=40) (actual time=0.006..0.007 rows=3 loops=1)

  • Filter: (isdeleted = 0)
87. 3,910.704 3,918.400 ↓ 3,600.0 3,600 25,280

Materialize (cost=2,108.83..4,297.14 rows=1 width=24) (actual time=0.000..0.155 rows=3,600 loops=25,280)

88. 0.380 7.696 ↓ 3,600.0 3,600 1

Nested Loop (cost=2,108.83..4,297.14 rows=1 width=24) (actual time=0.933..7.696 rows=3,600 loops=1)

89. 0.067 3.116 ↓ 600.0 600 1

Nested Loop (cost=2,108.27..4,295.62 rows=1 width=32) (actual time=0.921..3.116 rows=600 loops=1)

90. 0.200 1.249 ↓ 600.0 600 1

Hash Join (cost=2,107.84..4,287.21 rows=1 width=16) (actual time=0.910..1.249 rows=600 loops=1)

  • Hash Cond: (uipriority.insightid = uipreference.insightid)
91. 0.167 0.371 ↓ 1.0 600 1

Bitmap Heap Scan on userinsightpriority uipriority (cost=24.97..2,202.13 rows=586 width=8) (actual time=0.219..0.371 rows=600 loops=1)

  • Recheck Cond: (userid = 9,046)
  • Filter: (isdeleted = 0)
  • Heap Blocks: exact=33
92. 0.204 0.204 ↓ 3.4 1,969 1

Bitmap Index Scan on userinsightpriority_userid_idx (cost=0.00..24.82 rows=586 width=0) (actual time=0.204..0.204 rows=1,969 loops=1)

  • Index Cond: (userid = 9,046)
93. 0.085 0.678 ↓ 1.0 600 1

Hash (cost=2,075.54..2,075.54 rows=586 width=8) (actual time=0.677..0.678 rows=600 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 32kB
94. 0.473 0.593 ↓ 1.0 600 1

Bitmap Heap Scan on userinsightpreference uipreference (cost=12.97..2,075.54 rows=586 width=8) (actual time=0.187..0.593 rows=600 loops=1)

  • Recheck Cond: (userid = 9,046)
  • Filter: (status = ANY ('{0,2}'::bigint[]))
  • Heap Blocks: exact=568
95. 0.120 0.120 ↓ 1.0 600 1

Bitmap Index Scan on userinsightpreference_userid_idx (cost=0.00..12.82 rows=586 width=0) (actual time=0.120..0.120 rows=600 loops=1)

  • Index Cond: (userid = 9,046)
96. 1.800 1.800 ↑ 1.0 1 600

Index Scan using pk_insights_insightid on insights (cost=0.43..8.40 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=600)

  • Index Cond: (insightid = uipriority.insightid)
  • Filter: (expirydate >= now())
97. 4.200 4.200 ↓ 1.2 6 600

Index Scan using unique_insightid_entitytype_and_entityid on insightassociations ia (cost=0.56..1.47 rows=5 width=24) (actual time=0.003..0.007 rows=6 loops=600)

  • Index Cond: (insightid = insights.insightid)
  • Filter: ((isdeleted = 0) OR (isdeleted IS NULL))
98. 1.800 1.800 ↑ 1.0 1 900

Index Scan using unique_localecustomertype_localeid_customertypeid on localecustomertype lct (cost=0.15..6.84 rows=1 width=40) (actual time=0.001..0.002 rows=1 loops=900)

  • Index Cond: ((customertypeid = ct.customertypeid) AND (localeid = 10))
  • Filter: (isdeleted = 0)
99. 0.900 0.900 ↑ 1.0 1 900

Index Scan using pk_entitytypes_entitytypeid on entitytypes et (cost=0.13..0.15 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=900)

  • Index Cond: (entitytypeid = ia.entitytypeid)
  • Filter: (type = 'customer'::text)
100. 1.800 1.800 ↑ 8.0 1 900

Seq Scan on refresh_cycles_view rf (cost=0.00..27.66 rows=8 width=8) (actual time=0.001..0.002 rows=1 loops=900)

  • Filter: (rank = ANY ('{2}'::bigint[]))
  • Rows Removed by Filter: 20