explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uFXB

Settings
# exclusive inclusive rows x rows loops node
1. 8.487 582,074.075 ↑ 1.0 1 1

Aggregate (cost=1,091,086.54..1,091,086.59 rows=1 width=264) (actual time=582,074.075..582,074.075 rows=1 loops=1)

  • Output: count(DISTINCT base.user_id), sum(base.nsaleable), count(DISTINCT base.user_id) FILTER (WHERE (COALESCE(base.attempts, '0'::bigint) = 0)), count(DISTINCT base.user_id) FILTER (WHERE (COALESCE(base.attempts, '0'::bigint) = 1)), count(DISTINCT base (...)
2.          

CTE base

3. 49.440 582,044.097 ↓ 3,778.0 3,778 1

Nested Loop Anti Join (cost=271,883.70..1,091,086.41 rows=1 width=168) (actual time=77.066..582,044.097 rows=3,778 loops=1)

  • Output: usl.user_id, (count(*)), (count(*) FILTER (WHERE (COALESCE((CASE WHEN ((las.is_customer = 1) AND (las.enable_diy = 1)) THEN 1 ELSE 0 END), 0) = 1))), (count(*) FILTER (WHERE (COALESCE((CASE WHEN ((las.is_customer = 1) AND (las.enable_diy (...)
4. 22.731 581,460.177 ↓ 6,288.0 6,288 1

Nested Loop Left Join (cost=271,883.28..1,091,081.31 rows=1 width=154) (actual time=76.943..581,460.177 rows=6,288 loops=1)

  • Output: usl.user_id, (count(*)), ((array_agg(cis_calls.dispo ORDER BY cis_calls.log_date DESC))[1]), (sum(cis_subscriptions_1.accounts)), (sum(cis_subscriptions_1.accounts) FILTER (WHERE (cis_subscriptions_1.sub_oic <> ALL ('{System,PORTFOL (...)
5. 25.272 578,853.078 ↓ 6,288.0 6,288 1

Nested Loop Left Join (cost=271,850.62..1,091,048.63 rows=1 width=153) (actual time=76.646..578,853.078 rows=6,288 loops=1)

  • Output: usl.user_id, usl.created_at, (count(*)), ((array_agg(cis_calls.dispo ORDER BY cis_calls.log_date DESC))[1]), (sum(cis_subscriptions_1.accounts)), (sum(cis_subscriptions_1.accounts) FILTER (WHERE (cis_subscriptions_1.sub_oic <> (...)
6. 31.287 506,346.030 ↓ 6,288.0 6,288 1

Nested Loop (cost=271,817.96..1,091,015.95 rows=1 width=144) (actual time=64.563..506,346.030 rows=6,288 loops=1)

  • Output: usl.user_id, usl.created_at, (count(*)), ((array_agg(cis_calls.dispo ORDER BY cis_calls.log_date DESC))[1]), (sum(cis_subscriptions_1.accounts)), (sum(cis_subscriptions_1.accounts) FILTER (WHERE (cis_subscriptions_1.sub_ (...)
7. 46.192 490,208.663 ↓ 9,364.0 9,364 1

Nested Loop Left Join (cost=271,086.88..1,090,284.84 rows=1 width=128) (actual time=59.503..490,208.663 rows=9,364 loops=1)

  • Output: usl.user_id, usl.created_at, cp.customer_profile_id, (count(*)), ((array_agg(cis_calls.dispo ORDER BY cis_calls.log_date DESC))[1]), (sum(cis_subscriptions_1.accounts)), (sum(cis_subscriptions_1.accounts) FILTER (W (...)
8. 1,378.451 482,231.163 ↓ 9,364.0 9,364 1

Nested Loop Left Join (cost=267,450.44..1,086,648.36 rows=1 width=64) (actual time=57.988..482,231.163 rows=9,364 loops=1)

  • Output: usl.user_id, usl.created_at, cp.customer_profile_id, (count(*)), ((array_agg(cis_calls.dispo ORDER BY cis_calls.log_date DESC))[1])
9. 63.658 28,065.856 ↓ 9,364.0 9,364 1

Nested Loop (cost=1.13..819,199.02 rows=1 width=24) (actual time=0.947..28,065.856 rows=9,364 loops=1)

  • Output: usl.user_id, usl.created_at, cp.customer_profile_id
10. 18,842.486 26,026.294 ↓ 35,284.0 35,284 1

Index Scan using idx_user_id_created_at_usl on public.utm_source_log usl (cost=0.56..819,083.71 rows=1 width=16) (actual time=0.886..26,026.294 rows=35,284 loops=1)

  • Output: usl.id, usl.user_id, usl.utm_source_id, usl.utm_source_text, usl.utm_campaign, usl.utm_content, usl.utm_medium, usl.utm_source, usl.created_at, usl.inserted_at
  • Index Cond: ((usl.created_at >= '2019-04-07 00:00:00'::timestamp without time zone) AND (usl.created_at < '2019-04-08 00:00:00'::timestamp without time zone))
  • Filter: ((usl.id = (SubPlan 3)) AND (month_diff((SubPlan 2), '2019-04-07 00:00:00'::timestamp without time zone) > 0))
  • Rows Removed by Filter: 37012
11.          

SubPlan (forIndex Scan)

12. 216.888 578.368 ↑ 1.0 1 72,296

Aggregate (cost=2.99..3.00 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=72,296)

  • Output: min(utm_source_log.id)
13. 361.480 361.480 ↓ 2.0 2 72,296

Index Scan using idx_user_id_created_at_usl on public.utm_source_log (cost=0.56..2.99 rows=1 width=8) (actual time=0.004..0.005 rows=2 loops=72,296)

  • Output: utm_source_log.id, utm_source_log.user_id, utm_source_log.utm_source_id, utm_source_log.utm_source_text, utm_source_log.utm_campaign, utm_source_log.utm_content, utm_source_log.utm_m (...)
  • Index Cond: ((utm_source_log.user_id = usl.user_id) AND (utm_source_log.created_at >= '2019-04-07 00:00:00'::timestamp without time zone) AND (utm_source_log.created_at < '2019-04-08 00:00:0 (...)
14. 361.235 6,605.440 ↑ 1.0 1 51,605

Aggregate (cost=11.52..11.53 rows=1 width=8) (actual time=0.127..0.128 rows=1 loops=51,605)

  • Output: min(customer_profiles_1.created_on)
15. 6,244.205 6,244.205 ↑ 1.5 6 51,605

Index Scan using idx_user_id_customer_profiles on public.customer_profiles customer_profiles_1 (cost=0.56..11.50 rows=9 width=8) (actual time=0.080..0.121 rows=6 loops=51,605)

  • Output: customer_profiles_1.id, customer_profiles_1.customer_profile_id, customer_profiles_1.user_id, customer_profiles_1.report_source, customer_profiles_1.report_id, customer_profiles_1.cr (...)
  • Index Cond: (customer_profiles_1.user_id = usl.user_id)
16. 468.064 1,975.904 ↓ 0.0 0 35,284

Index Scan using idx_user_id_customer_profiles on public.customer_profiles cp (cost=0.56..115.30 rows=1 width=12) (actual time=0.018..0.056 rows=0 loops=35,284)

  • Output: cp.id, cp.customer_profile_id, cp.user_id, cp.report_source, cp.report_id, cp.credit_score, cp.report_date, cp.filename_prefix, cp.occupation, cp.income, cp.frequency, cp.income_indicator, cp.cust (...)
  • Index Cond: (cp.user_id = usl.user_id)
  • Filter: (((cp.customer_type)::text = 'Red'::text) AND (cp.customer_profile_id = (SubPlan 1)))
  • Rows Removed by Filter: 8
17.          

SubPlan (forIndex Scan)

18. 555.520 1,507.840 ↑ 1.0 1 79,360

Aggregate (cost=11.52..11.53 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=79,360)

  • Output: max(customer_profiles.customer_profile_id)
19. 952.320 952.320 ↓ 1.2 11 79,360

Index Scan using idx_user_id_customer_profiles on public.customer_profiles (cost=0.56..11.50 rows=9 width=8) (actual time=0.003..0.012 rows=11 loops=79,360)

  • Output: customer_profiles.id, customer_profiles.customer_profile_id, customer_profiles.user_id, customer_profiles.report_source, customer_profiles.report_id, customer_profiles.credit_score, (...)
  • Index Cond: (customer_profiles.user_id = cp.user_id)
20. 292,109.980 452,786.856 ↑ 1.0 1 9,364

Aggregate (cost=267,449.31..267,449.32 rows=1 width=40) (actual time=48.353..48.354 rows=1 loops=9,364)

  • Output: count(*), (array_agg(cis_calls.dispo ORDER BY cis_calls.log_date DESC))[1]
21. 148,110.388 160,676.876 ↑ 118.5 32,702 9,364

Bitmap Heap Scan on cis.cis_calls (cost=42,798.47..248,067.35 rows=3,876,391 width=11) (actual time=1.390..17.159 rows=32,702 loops=9,364)

  • Output: cis_calls.log_id, cis_calls.lead_id, cis_calls.user_id, cis_calls.product_status, cis_calls.crm_status_text, cis_calls.dispo, cis_calls.log_date, cis_calls.oic, cis_calls.oic_name
  • Recheck Cond: (cis_calls.log_date >= usl.created_at)
  • Heap Blocks: exact=4129524
22. 12,566.488 12,566.488 ↑ 118.5 32,702 9,364

Bitmap Index Scan on cis_calls__index_on_log_date (cost=0.00..41,829.37 rows=3,876,391 width=0) (actual time=1.342..1.342 rows=32,702 loops=9,364)

  • Index Cond: (cis_calls.log_date >= usl.created_at)
23. 3,052.664 7,931.308 ↑ 1.0 1 9,364

Aggregate (cost=3,636.44..3,636.45 rows=1 width=64) (actual time=0.847..0.847 rows=1 loops=9,364)

  • Output: sum(cis_subscriptions_1.accounts), sum(cis_subscriptions_1.accounts) FILTER (WHERE (cis_subscriptions_1.sub_oic <> ALL ('{System,PORTFOLIO}'::text[])))
24. 4,878.644 4,878.644 ↑ 113.1 478 9,364

Index Scan using cis_subscriptions__index_on_payment_date on cis.cis_subscriptions cis_subscriptions_1 (cost=0.42..3,230.96 rows=54,064 width=15) (actual time=0.011..0.521 rows=478 loops=9,364)

  • Output: cis_subscriptions_1.subscription_id, cis_subscriptions_1.order_id, cis_subscriptions_1.user_service_order_id, cis_subscriptions_1.transaction_id, cis_subscriptions_1.user_id, cis_subscriptions_1.lead_id (...)
  • Index Cond: (cis_subscriptions_1.payment_date >= usl.created_at)
25. 46.820 16,106.080 ↑ 1.0 1 9,364

Aggregate (cost=731.08..731.09 rows=1 width=24) (actual time=1.720..1.720 rows=1 loops=9,364)

  • Output: count(*), count(*) FILTER (WHERE (COALESCE((CASE WHEN ((las.is_customer = 1) AND (las.enable_diy = 1)) THEN 1 ELSE 0 END), 0) = 1)), count(*) FILTER (WHERE (COALESCE((CASE WHEN ((las.is_customer = 1) AND (las.enabl (...)
  • Filter: (count(*) > 0)
  • Rows Removed by Filter: 0
26. 50.376 16,059.260 ↑ 33.0 1 9,364

Nested Loop Left Join (cost=16.66..730.58 rows=33 width=4) (actual time=1.369..1.715 rows=1 loops=9,364)

  • Output: (CASE WHEN ((las.is_customer = 1) AND (las.enable_diy = 1)) THEN 1 ELSE 0 END)
27. 160.649 15,188.408 ↑ 33.0 1 9,364

Nested Loop (cost=2.74..230.28 rows=33 width=12) (actual time=1.313..1.622 rows=1 loops=9,364)

  • Output: cpa.product_family_id, cpa.lender_id, cpa.account_status_master_id
28. 234.041 14,476.744 ↑ 6.4 12 9,364

Hash Join (cost=2.31..10.25 rows=77 width=16) (actual time=1.040..1.546 rows=12 loops=9,364)

  • Output: cpa.product_family_id, cpa.lender_id, cpa.account_status_master_id, acs.id
  • Hash Cond: ((cpa.account_status)::text = (acs.account_status_text)::text)
29. 14,242.644 14,242.644 ↑ 6.8 12 9,364

Index Scan using idx_customer_profile_id_cpa on public.customer_profile_accounts cpa (cost=0.57..7.43 rows=82 width=27) (actual time=1.034..1.521 rows=12 loops=9,364)

  • Output: cpa.customer_profile_account_id, cpa.customer_profile_id, cpa.account_name, cpa.account_type, cpa.account_no, cpa.ownership, cpa.credit_limit, cpa.sanctioned_amount, cpa.current_balance, cpa (...)
  • Index Cond: (cpa.customer_profile_id = cp.customer_profile_id)
30. 0.021 0.059 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=520) (actual time=0.059..0.059 rows=33 loops=1)

  • Output: acs.account_status_text, acs.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
31. 0.038 0.038 ↑ 1.0 33 1

Seq Scan on master_tables.account_status acs (cost=0.00..1.33 rows=33 width=520) (actual time=0.021..0.038 rows=33 loops=1)

  • Output: acs.account_status_text, acs.id
32. 551.015 551.015 ↓ 0.0 0 110,203

Index Scan using idx_saleable_lsa on master_tables.lender_saleable_accounts lsa (cost=0.42..2.85 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=110,203)

  • Output: lsa.id, lsa.lender_id, lsa.product_family_id, lsa.account_status_id, lsa.is_active, lsa.created_at, lsa.updated_at
  • Index Cond: ((lsa.lender_id = cpa.lender_id) AND (lsa.product_family_id = cpa.product_family_id) AND (lsa.account_status_id = acs.id))
  • Filter: (lsa.is_active = 1)
  • Rows Removed by Filter: 0
33. 46.224 820.476 ↑ 1.0 1 11,556

Limit (cost=13.92..15.14 rows=1 width=4) (actual time=0.070..0.071 rows=1 loops=11,556)

  • Output: (CASE WHEN ((las.is_customer = 1) AND (las.enable_diy = 1)) THEN 1 ELSE 0 END)
34. 46.224 774.252 ↑ 1.0 1 11,556

Bitmap Heap Scan on master_tables.lender_account_status las (cost=13.92..15.14 rows=1 width=4) (actual time=0.067..0.067 rows=1 loops=11,556)

  • Output: CASE WHEN ((las.is_customer = 1) AND (las.enable_diy = 1)) THEN 1 ELSE 0 END
  • Recheck Cond: ((las.account_status_id = cpa.account_status_master_id) AND (las.product_family_id = cpa.product_family_id) AND (las.lender_id = cpa.lender_id))
  • Heap Blocks: exact=8183
35. 81.642 728.028 ↓ 0.0 0 11,556

BitmapAnd (cost=13.92..13.92 rows=1 width=0) (actual time=0.063..0.063 rows=0 loops=11,556)

36. 184.896 184.896 ↓ 1.3 258 11,556

Bitmap Index Scan on idx_las_account_status_id (cost=0.00..4.21 rows=203 width=0) (actual time=0.016..0.016 rows=258 loops=11,556)

  • Index Cond: (las.account_status_id = cpa.account_status_master_id)
37. 288.900 288.900 ↓ 1.8 403 11,556

Bitmap Index Scan on idx_las_product_family_id (cost=0.00..4.32 rows=218 width=0) (actual time=0.025..0.025 rows=403 loops=11,556)

  • Index Cond: (las.product_family_id = cpa.product_family_id)
38. 172.590 172.590 ↑ 1.1 263 11,506

Bitmap Index Scan on idx_las_lender_id (cost=0.00..4.89 rows=295 width=0) (actual time=0.015..0.015 rows=263 loops=11,506)

  • Index Cond: (las.lender_id = cpa.lender_id)
39. 12.576 72,481.776 ↓ 0.0 0 6,288

Limit (cost=32.66..32.66 rows=1 width=235) (actual time=11.527..11.527 rows=0 loops=6,288)

  • Output: ps.status, NULL::character varying(100), ll.updated_at
40. 44.016 72,469.200 ↓ 0.0 0 6,288

Sort (cost=32.66..32.66 rows=1 width=235) (actual time=11.525..11.525 rows=0 loops=6,288)

  • Output: ps.status, NULL::character varying(100), ll.updated_at
  • Sort Key: ll.updated_at
  • Sort Method: quicksort Memory: 25kB
41. 23.148 72,425.184 ↑ 1.0 1 6,288

Nested Loop Left Join (cost=1.55..32.65 rows=1 width=235) (actual time=9.613..11.518 rows=1 loops=6,288)

  • Output: ps.status, NULL::character varying(100), ll.updated_at
  • Inner Unique: true
42. 20.199 72,387.456 ↑ 1.0 1 6,288

Nested Loop (cost=1.27..31.40 rows=1 width=12) (actual time=9.610..11.512 rows=1 loops=6,288)

  • Output: ll.updated_at, ll.product_status_id
  • Inner Unique: true
43. 61.244 72,337.152 ↑ 1.5 2 6,288

Nested Loop (cost=1.14..30.92 rows=3 width=16) (actual time=6.382..11.504 rows=2 loops=6,288)

  • Output: ll.updated_at, ll.product_status_id, ll.lead_log_type_id
44. 1,515.408 1,515.408 ↓ 3.0 3 6,288

Index Scan using idx_user_id_leads on public.leads l (cost=0.56..6.88 rows=1 width=8) (actual time=0.207..0.241 rows=3 loops=6,288)

  • Output: l.id, l.user_id, l.product_family_id, l.lender_offer_id, l.lead_source_id, l.offer_reference_number, l.offer_application_number, l.lead_attempt_id, l.lead_priority_id, l.product_status_id, l (...)
  • Index Cond: (l.user_id = usl.user_id)
  • Filter: (((l.type)::character varying)::text = 'CIS'::text)
  • Rows Removed by Filter: 3
45. 70,760.500 70,760.500 ↓ 0.0 0 20,660

Index Scan using idx_lead_id_lead_logs on public.lead_logs ll (cost=0.57..23.94 rows=9 width=36) (actual time=2.739..3.425 rows=0 loops=20,660)

  • Output: ll.id, ll.lead_id, ll.product_status_id, ll.crm_status_id, ll.cmol_status_id, ll.source, ll.lead_log_type_id, ll.updated_by, ll.lead_attempt_id, ll.updated_at, ll.created_at, ll.appops_statu (...)
  • Index Cond: (ll.lead_id = l.id)
  • Filter: (ll.updated_at >= usl.created_at)
  • Rows Removed by Filter: 17
46. 30.105 30.105 ↓ 0.0 0 10,035

Index Scan using lead_log_types_pkey on master_tables.lead_log_types llt (cost=0.14..0.16 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=10,035)

  • Output: llt.id, llt.type, llt.is_active, llt.modified_ts
  • Index Cond: (llt.id = ll.lead_log_type_id)
  • Filter: ((llt.type)::text = 'Product Status Change'::text)
  • Rows Removed by Filter: 1
47. 14.580 14.580 ↑ 1.0 1 4,860

Index Scan using product_status_pkey on master_tables.product_status ps (cost=0.28..1.25 rows=1 width=13) (actual time=0.003..0.003 rows=1 loops=4,860)

  • Output: ps.id, ps.status, ps.status_text, ps.is_active, ps.display_order, ps.is_default, ps.type, ps.display_text, ps.modified_ts, ps.inserted_at
  • Index Cond: (ll.product_status_id = ps.id)
48. 18.864 2,584.368 ↑ 1.0 1 6,288

Limit (cost=32.66..32.66 rows=1 width=235) (actual time=0.410..0.411 rows=1 loops=6,288)

  • Output: ps_1.status, NULL::character varying(100), ll_1.updated_at
49. 150.912 2,565.504 ↑ 1.0 1 6,288

Sort (cost=32.66..32.66 rows=1 width=235) (actual time=0.408..0.408 rows=1 loops=6,288)

  • Output: ps_1.status, NULL::character varying(100), ll_1.updated_at
  • Sort Key: ll_1.updated_at DESC
  • Sort Method: top-N heapsort Memory: 25kB
50. 230.998 2,414.592 ↓ 25.0 25 6,288

Nested Loop Left Join (cost=1.55..32.65 rows=1 width=235) (actual time=0.062..0.384 rows=25 loops=6,288)

  • Output: ps_1.status, NULL::character varying(100), ll_1.updated_at
  • Inner Unique: true
51. 593.056 1,867.536 ↓ 25.0 25 6,288

Nested Loop (cost=1.27..31.40 rows=1 width=12) (actual time=0.053..0.297 rows=25 loops=6,288)

  • Output: ll_1.updated_at, ll_1.product_status_id
  • Inner Unique: true
52. 327.888 924.336 ↓ 18.7 56 6,288

Nested Loop (cost=1.14..30.92 rows=3 width=16) (actual time=0.019..0.147 rows=56 loops=6,288)

  • Output: ll_1.updated_at, ll_1.product_status_id, ll_1.lead_log_type_id
53. 100.608 100.608 ↓ 3.0 3 6,288

Index Scan using idx_user_id_leads on public.leads l_1 (cost=0.56..6.88 rows=1 width=8) (actual time=0.008..0.016 rows=3 loops=6,288)

  • Output: l_1.id, l_1.user_id, l_1.product_family_id, l_1.lender_offer_id, l_1.lead_source_id, l_1.offer_reference_number, l_1.offer_application_number, l_1.lead_attempt_id, l_1.lead_priority_id, l_1.produc (...)
  • Index Cond: (l_1.user_id = usl.user_id)
  • Filter: (((l_1.type)::character varying)::text = 'CIS'::text)
  • Rows Removed by Filter: 3
54. 495.840 495.840 ↓ 1.9 17 20,660

Index Scan using idx_lead_id_lead_logs on public.lead_logs ll_1 (cost=0.57..23.94 rows=9 width=36) (actual time=0.006..0.024 rows=17 loops=20,660)

  • Output: ll_1.id, ll_1.lead_id, ll_1.product_status_id, ll_1.crm_status_id, ll_1.cmol_status_id, ll_1.source, ll_1.lead_log_type_id, ll_1.updated_by, ll_1.lead_attempt_id, ll_1.updated_at, ll_1.created_at, (...)
  • Index Cond: (ll_1.lead_id = l_1.id)
  • Filter: (ll_1.updated_at < usl.created_at)
  • Rows Removed by Filter: 0
55. 350.144 350.144 ↓ 0.0 0 350,144

Index Scan using lead_log_types_pkey on master_tables.lead_log_types llt_1 (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=350,144)

  • Output: llt_1.id, llt_1.type, llt_1.is_active, llt_1.modified_ts
  • Index Cond: (llt_1.id = ll_1.lead_log_type_id)
  • Filter: ((llt_1.type)::text = 'Product Status Change'::text)
  • Rows Removed by Filter: 1
56. 316.058 316.058 ↑ 1.0 1 158,029

Index Scan using product_status_pkey on master_tables.product_status ps_1 (cost=0.28..1.25 rows=1 width=13) (actual time=0.002..0.002 rows=1 loops=158,029)

  • Output: ps_1.id, ps_1.status, ps_1.status_text, ps_1.is_active, ps_1.display_order, ps_1.is_default, ps_1.type, ps_1.display_text, ps_1.modified_ts, ps_1.inserted_at
  • Index Cond: (ll_1.product_status_id = ps_1.id)
57. 534.480 534.480 ↓ 0.0 0 6,288

Index Scan using cis_subscriptions__index_on_user_id on cis.cis_subscriptions (cost=0.42..2.84 rows=1 width=4) (actual time=0.085..0.085 rows=0 loops=6,288)

  • Output: cis_subscriptions.subscription_id, cis_subscriptions.order_id, cis_subscriptions.user_service_order_id, cis_subscriptions.transaction_id, cis_subscriptions.user_id, cis_subscriptions.lead_id, cis_subscriptions.is_offline_payment, ci (...)
  • Index Cond: (cis_subscriptions.user_id = usl.user_id)
  • Filter: (cis_subscriptions.payment_date < '2019-04-07 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 0
58. 582,065.588 582,065.588 ↓ 852.0 852 1

CTE Scan on base (cost=0.00..0.02 rows=1 width=120) (actual time=3,055.303..582,065.588 rows=852 loops=1)

  • Output: base.user_id, base.nsaleable, base.saleable_ldb, base.saleable_nonldb, base.attempts, base.latest_dispo, base.accounts, base.assisted_accounts, base.queue
  • Filter: (base.queue ~* '00 Q'::text)
  • Rows Removed by Filter: 2926