explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2hWH

Settings
# exclusive inclusive rows x rows loops node
1. 963.494 72,252.909 ↑ 8.0 2,319,871 1

Unique (cost=21,295,515.28..22,784,379.92 rows=18,610,808 width=385) (actual time=70,735.436..72,252.909 rows=2,319,871 loops=1)

  • Output: wip.batch_id, pf.inquiry_id, gr.response_cd, gbu.rdc_firm_nbr, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, (COALESCE(pf.concatname_u, (pf.concatname)::text)), pf.concatname_u, (CASE WHEN (pf.business_name IS NULL) THEN 'P'::text ELSE 'O'::text END), pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, al.cvip_code, (to_char(al.alert_dt, 'YYYY-MM-DD HH:MI:SS'::text)), wip.submitted_ts, pf.taxid, pf.inquiry_notes, (CASE WHEN ((pf.pf_status)::text = 'ACT'::text) THEN pf.look_back ELSE 'N'::character varying END), pf.record_in_dt, pf.erase_dt
  • Buffers: shared hit=197,496 read=1,087,133, temp read=906,465 written=943,582
  • I/O Timings: read=2,597.241
2. 3,239.803 71,289.415 ↑ 8.0 2,319,894 1

Sort (cost=21,295,515.28..21,342,042.30 rows=18,610,808 width=385) (actual time=70,735.435..71,289.415 rows=2,319,894 loops=1)

  • Output: wip.batch_id, pf.inquiry_id, gr.response_cd, gbu.rdc_firm_nbr, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, (COALESCE(pf.concatname_u, (pf.concatname)::text)), pf.concatname_u, (CASE WHEN (pf.business_name IS NULL) THEN 'P'::text ELSE 'O'::text END), pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, al.cvip_code, (to_char(al.alert_dt, 'YYYY-MM-DD HH:MI:SS'::text)), wip.submitted_ts, pf.taxid, pf.inquiry_notes, (CASE WHEN ((pf.pf_status)::text = 'ACT'::text) THEN pf.look_back ELSE 'N'::character varying END), pf.record_in_dt, pf.erase_dt
  • Sort Key: wip.batch_id, pf.inquiry_id, gr.response_cd, gbu.rdc_firm_nbr, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, (COALESCE(pf.concatname_u, (pf.concatname)::text)), pf.concatname_u, (CASE WHEN (pf.business_name IS NULL) THEN 'P'::text ELSE 'O'::text END), pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, al.cvip_code, (to_char(al.alert_dt, 'YYYY-MM-DD HH:MI:SS'::text)), wip.submitted_ts, pf.taxid, pf.inquiry_notes, (CASE WHEN ((pf.pf_status)::text = 'ACT'::text) THEN pf.look_back ELSE 'N'::character varying END), pf.record_in_dt, pf.erase_dt
  • Sort Method: external merge Disk: 263,936kB
  • Buffers: shared hit=197,496 read=1,087,133, temp read=906,465 written=943,582
  • I/O Timings: read=2,597.241
3. 462.485 68,049.612 ↑ 8.0 2,319,894 1

Nested Loop (cost=8,101,513.25..9,124,943.45 rows=18,610,808 width=385) (actual time=66,404.240..68,049.612 rows=2,319,894 loops=1)

  • Output: wip.batch_id, pf.inquiry_id, gr.response_cd, gbu.rdc_firm_nbr, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, COALESCE(pf.concatname_u, (pf.concatname)::text), pf.concatname_u, CASE WHEN (pf.business_name IS NULL) THEN 'P'::text ELSE 'O'::text END, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, al.cvip_code, to_char(al.alert_dt, 'YYYY-MM-DD HH:MI:SS'::text), wip.submitted_ts, pf.taxid, pf.inquiry_notes, CASE WHEN ((pf.pf_status)::text = 'ACT'::text) THEN pf.look_back ELSE 'N'::character varying END, pf.record_in_dt, pf.erase_dt
  • Buffers: shared hit=197,496 read=1,087,133, temp read=828,850 written=865,869
  • I/O Timings: read=2,597.241
4. 0.012 0.012 ↑ 1.0 1 1

Index Scan using ix_grid_biz_unit_idx_grid_biz_unit on dbo.grid_biz_unit gbu (cost=0.28..8.30 rows=1 width=13) (actual time=0.008..0.012 rows=1 loops=1)

  • Output: gbu.biz_unit_id, gbu.rdc_firm_nbr, gbu.name, gbu.cdc_firm_nbr, gbu.cdc_test_firm_nbr, gbu.parent_id, gbu.security_pin, gbu.deleted_flag, gbu.disabled_flag, gbu.test_flag, gbu.subscription_billing_flag, gbu.internal_firm_flag, gbu.product_review_flag, gbu.product_search_flag, gbu.factiva_reader_flag, gbu.review_customer_tracking_id_required, gbu.factiva_reader_license, gbu.batch_integration_flag, gbu.pm_flag, gbu.pm_group_only_delivery, gbu.pm_response_type, gbu.pm_fee, gbu.inquiry_fee, gbu.acct_owner, gbu.filter_profile_id, gbu.review_mode, gbu.review_max_results, gbu.review_tracking_id_req, gbu.entity_id_enabled, gbu.remember_me_enabled, gbu.rib_source_content, gbu.risk_score_rule_id, gbu.contract_date, gbu.subscription_inquiry_limit, gbu.disable_review_web_submission, gbu.rib_legacy_processing, gbu.rib_response_type, gbu.pm_rib_enabled, gbu.self_service_enabled, gbu.client_folder_report_enabled, gbu.rib_dedupe_excl_address_enabled, gbu.black_list_enabled, gbu.cvip_enabled, gbu.cvip_profile_id, gbu.mask_email_subj_inq_name, gbu.mask_email_subj_tracking_id, gbu.inquiry_notes_enabled, gbu.pgp_enabled, gbu.de_dupe_billing_enabled, gbu.riskcheck_enabled, gbu.aml_enabled, gbu.factiva_license_cnt, gbu.virtual_firm, gbu.parent_firm_nbr, gbu.inquiry_re_alert_days, gbu.search_pdf_download_enabled, gbu.search_event_filter_enabled, gbu.multi_column_sort_enabled, gbu.rib_response_version, gbu.metrics_response, gbu.lexisnexis_license_cnt, gbu.lexisnexis_reader_flag, gbu.lexisnexis_reader_license, gbu.aml_enabled_ws, gbu.riskcheck_enabled_ws, gbu.product_review_flag_ws, gbu.product_search_flag_ws, gbu.ip_whitelist_id, gbu.incl_articles_w_alerts, gbu.filter_alert, gbu.custom_alert_views_enabled, gbu.ws_schema_version, gbu.max_articles_per_entity, gbu.client_alert_decisioning_enabled, gbu.client_alert_dec_reason_codes_enabled, gbu.client_alert_dec_reason_req_for_alert, gbu.client_alert_dec_reason_req_for_nomatch, gbu.auto_assign_pm_reviews, gbu.additional_search_strategy_type, gbu.ofac_min_match_score, gbu.alertable_ilist_enabled, gbu.alert_integration_flag, gbu.search_result_hide_enabled, gbu.search_results_per_page, gbu.search_clean_search_enabled, gbu.subscription_pm_limit, gbu.supported_encoding, gbu.search_stats_name_capture_enabled, gbu.cust_comp_score_input_id, gbu.include_comp_score_flag, gbu.wss_delete_spreadsheet_files_upon_upload, gbu.search_full_address_enabled, gbu.search_dob_enabled, gbu.upload_record_limit, gbu.search_country_enabled, gbu.search_exact_match_enabled, gbu.search_entity_date_enabled, gbu.wss_search_1_1_enabled, gbu.search_min_score, gbu.alert_integration_send_nomatch_flag, gbu.client_alert_dec_force_all_decisions, gbu.include_decisioning_info_in_responses, gbu.screening_scope, gbu.product_notes, gbu.search_seat_cnt, gbu.fit_enabled, gbu.fit_threshold, gbu.salesforce_id, gbu.premium_content, gbu.sla, gbu.firm_group, gbu.firm_group_biz_unit_id, gbu.pm_pep_change_flag, gbu.email_alerts_for_icad_users_enabled, gbu.add_grid_search_to_pm, gbu.cascade_lf_batches_to_virtual_firms, gbu.wss_add_group_to_pm_default, gbu.rdc_view_enabled, gbu.cloud_extractable, gbu.rdc_id_lookup_enabled, gbu.conf_threshold_alert_enabled, gbu.rib_dedupe_pm_by_reporting_id_enabled, gbu.level_one_screening_enabled, gbu.level_one_nomatch_threshold, gbu.default_inquiry_type, gbu.sso_enabled, gbu.include_all_decisions_in_pm_rib_response, gbu.level_one_nomatch_threshold_person, gbu.level_one_nomatch_threshold_organization, gbu.lb_sla, gbu.lf_sla, gbu.client_alert_dec_time_to_close_report_link_enabled, gbu.emergency_mode_enabled, gbu.emergency_virtual_firm, gbu.client_alert_dec_include_all_decisions_in_pm, gbu.greylist_client_alert_dec_false_positive_matches, gbu.client_alert_dec_reopen_batch_enabled, gbu.rdc_view_extractable
  • Index Cond: (gbu.biz_unit_id = 101,389)
  • Buffers: shared hit=3
5. 1,179.060 67,587.115 ↑ 8.0 2,319,894 1

Hash Right Join (cost=8,101,512.97..8,845,773.04 rows=18,610,808 width=279) (actual time=66,404.219..67,587.115 rows=2,319,894 loops=1)

  • Output: wip.batch_id, wip.submitted_ts, grid_batch.biz_unit_id, pf.inquiry_id, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, pf.concatname_u, pf.concatname, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, pf.taxid, pf.inquiry_notes, pf.pf_status, pf.look_back, pf.record_in_dt, pf.erase_dt, gr.response_cd, al.cvip_code, al.alert_dt
  • Hash Cond: (((al.inq_id)::integer = pf.inquiry_id) AND (al.batch_id = wip.batch_id))
  • Buffers: shared hit=197,493 read=1,087,133, temp read=828,850 written=865,869
  • I/O Timings: read=2,597.241
6. 1.783 56.772 ↑ 2.0 8,646 1

Subquery Scan on al (cost=898.24..143,762.53 rows=17,033 width=56) (actual time=8.046..56.772 rows=8,646 loops=1)

  • Output: al.cvip_code, al.alert_dt, al.inq_id, al.batch_id
  • Buffers: shared hit=26,803
7. 8.428 54.989 ↑ 2.0 8,646 1

HashAggregate (cost=898.24..143,592.20 rows=17,033 width=58) (actual time=8.045..54.989 rows=8,646 loops=1)

  • Output: al_1.inq_id, al_1.batch_id, (SubPlan 1), al_1.history, max(al_1.alert_dt), al_1.cvip_code
  • Group Key: al_1.inq_id, al_1.batch_id, al_1.cvip_code, al_1.history
  • Buffers: shared hit=26,803
8. 3.331 3.331 ↓ 1.0 17,127 1

Seq Scan on dbo.alert_101389 al_1 (cost=0.00..685.33 rows=17,033 width=26) (actual time=0.016..3.331 rows=17,127 loops=1)

  • Output: al_1.alert_pk_id, al_1.alert_dt, al_1.alert_tracking_id, al_1.link, al_1.full_abstract, al_1.batch_id, al_1.inq_id, al_1.name, al_1.id, al_1.cvip_code, al_1.type, al_1.history
  • Filter: (NOT al_1.history)
  • Buffers: shared hit=515
9.          

SubPlan (for HashAggregate)

10. 8.646 43.230 ↑ 1.0 1 8,646

Aggregate (cost=8.36..8.37 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=8,646)

  • Output: string_agg((al_2.cvip_code)::text, ', '::text)
  • Buffers: shared hit=26,288
11. 0.000 34.584 ↑ 1.0 1 8,646

GroupAggregate (cost=8.32..8.34 rows=1 width=26) (actual time=0.004..0.004 rows=1 loops=8,646)

  • Output: al_2.inq_id, al_2.batch_id, al_2.cvip_code, al_2.history, NULL::timestamp without time zone
  • Group Key: al_2.inq_id, al_2.batch_id, al_2.cvip_code, al_2.history
  • Buffers: shared hit=26,288
12. 17.292 34.584 ↓ 2.0 2 8,646

Sort (cost=8.32..8.32 rows=1 width=18) (actual time=0.004..0.004 rows=2 loops=8,646)

  • Output: al_2.inq_id, al_2.batch_id, al_2.cvip_code, al_2.history
  • Sort Key: al_2.cvip_code, al_2.history
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=26,288
13. 17.292 17.292 ↓ 2.0 2 8,646

Index Scan using alert_idx4_101389 on dbo.alert_101389 al_2 (cost=0.29..8.31 rows=1 width=18) (actual time=0.002..0.002 rows=2 loops=8,646)

  • Output: al_2.inq_id, al_2.batch_id, al_2.cvip_code, al_2.history
  • Index Cond: ((al_2.batch_id = al_1.batch_id) AND (al_2.inq_id = al_1.inq_id))
  • Filter: (NOT al_2.history)
  • Buffers: shared hit=26,288
14. 94.072 66,351.283 ↑ 8.0 2,319,871 1

Hash (cost=7,221,689.61..7,221,689.61 rows=18,610,808 width=239) (actual time=66,351.283..66,351.283 rows=2,319,871 loops=1)

  • Output: wip.batch_id, wip.submitted_ts, grid_batch.biz_unit_id, pf.inquiry_id, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, pf.concatname_u, pf.concatname, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, pf.taxid, pf.inquiry_notes, pf.pf_status, pf.look_back, pf.record_in_dt, pf.erase_dt, gr.response_cd
  • Buckets: 16,384 Batches: 2,048 Memory Usage: 267kB
  • Buffers: shared hit=170,690 read=1,087,133, temp read=794,469 written=861,804
  • I/O Timings: read=2,597.241
15. 2,322.549 66,257.211 ↑ 8.0 2,319,871 1

Gather (cost=3,063,833.45..7,221,689.61 rows=18,610,808 width=239) (actual time=59,595.372..66,257.211 rows=2,319,871 loops=1)

  • Output: wip.batch_id, wip.submitted_ts, grid_batch.biz_unit_id, pf.inquiry_id, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, pf.concatname_u, pf.concatname, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, pf.taxid, pf.inquiry_notes, pf.pf_status, pf.look_back, pf.record_in_dt, pf.erase_dt, gr.response_cd
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=170,690 read=1,087,133, temp read=794,469 written=831,488
  • I/O Timings: read=2,597.241
16. 5,190.718 63,934.662 ↑ 10.0 773,290 3 / 3

Parallel Hash Left Join (cost=3,062,833.45..5,359,608.81 rows=7,754,503 width=239) (actual time=59,591.348..63,934.662 rows=773,290 loops=3)

  • Output: wip.batch_id, wip.submitted_ts, grid_batch.biz_unit_id, pf.inquiry_id, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, pf.concatname_u, pf.concatname, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, pf.taxid, pf.inquiry_notes, pf.pf_status, pf.look_back, pf.record_in_dt, pf.erase_dt, gr.response_cd
  • Hash Cond: ((wip.batch_id = gr.batch_id) AND (pf.inquiry_id = gr.inquiry_id))
  • Filter: ((NOT gr.batch_reset) OR (gr.batch_reset IS NULL))
  • Buffers: shared hit=170,690 read=1,087,133, temp read=794,469 written=831,488
  • I/O Timings: read=2,597.241
  • Worker 0: actual time=59,591.328..63889.863 rows=772,579 loops=1
  • Buffers: shared hit=57,434 read=354,432, temp read=265,194 written=272,744
  • I/O Timings: read=857.864
  • Worker 1: actual time=59,587.998..63886.010 rows=771,449 loops=1
  • Buffers: shared hit=56,913 read=360,310, temp read=263,139 written=272,780
  • I/O Timings: read=855.031
17. 355.007 1,364.000 ↑ 10.0 773,290 3 / 3

Parallel Hash Join (cost=134,721.27..390,175.80 rows=7,754,503 width=236) (actual time=1,041.264..1,364.000 rows=773,290 loops=3)

  • Output: wip.batch_id, wip.submitted_ts, grid_batch.biz_unit_id, pf.inquiry_id, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, pf.concatname_u, pf.concatname, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, pf.taxid, pf.inquiry_notes, pf.pf_status, pf.look_back, pf.record_in_dt, pf.erase_dt
  • Hash Cond: (COALESCE(grid_batch.pf_batch_id, grid_batch.batch_id) = pf.batch_id)
  • Buffers: shared hit=170,510, temp read=28,628 written=32,024
  • Worker 0: actual time=1,041.416..1365.514 rows=798,596 loops=1
  • Buffers: shared hit=57,356, temp read=9,916 written=10,688
  • Worker 1: actual time=1,041.874..1366.672 rows=707,549 loops=1
  • Buffers: shared hit=56,840, temp read=8,790 written=10,632
18. 215.087 388.073 ↑ 1.2 34,406 3 / 3

Parallel Hash Join (cost=39,716.75..191,589.19 rows=42,505 width=36) (actual time=20.042..388.073 rows=34,406 loops=3)

  • Output: wip.batch_id, wip.submitted_ts, grid_batch.batch_id, grid_batch.pf_batch_id, grid_batch.biz_unit_id
  • Inner Unique: true
  • Hash Cond: (wip.batch_id = grid_batch.batch_id)
  • Buffers: shared hit=129,043
  • Worker 0: actual time=20.089..388.227 rows=34,524 loops=1
  • Buffers: shared hit=43,501
  • Worker 1: actual time=19.951..388.325 rows=34,455 loops=1
  • Buffers: shared hit=43,087
19. 153.235 153.235 ↑ 1.3 1,300,904 3 / 3

Parallel Seq Scan on dbo.grid_wip wip (cost=0.00..147,597.49 rows=1,628,552 width=16) (actual time=0.007..153.235 rows=1,300,904 loops=3)

  • Output: wip.batch_id, wip.inq_cnt, wip.search_type, wip.batch_type, wip.submitted_ts, wip.completed_ts, wip.bal_ts, wip.irf_ts, wip.urf_ts, wip.kyc_submitted_ts, wip.kyc_processed_ts, wip.kyc_submitted_cnt, wip.kyc_processed_cnt, wip.search_processed_cnt, wip.alert_cnt, wip.pm_date, wip.purge_ts, wip.pend_purge_job_ts, wip.system_id, wip.load_only_inquiry_count, wip.kyc_accepted_cnt, wip.kyc_reviewed_cnt, wip.kyc_submitted_grid_match_cnt, wip.alert_grid_match_cnt, wip.kyc_submitted_list_match_cnt, wip.alert_list_match_cnt, wip.arf_ts
  • Filter: (wip.inq_cnt >= 0)
  • Rows Removed by Filter: 336
  • Buffers: shared hit=127,240
  • Worker 0: actual time=0.008..153.664 rows=1,298,710 loops=1
  • Buffers: shared hit=42,442
  • Worker 1: actual time=0.007..153.926 rows=1,305,130 loops=1
  • Buffers: shared hit=42,719
20. 9.503 19.751 ↑ 1.3 34,408 3 / 3

Parallel Hash (cost=39,175.08..39,175.08 rows=43,333 width=20) (actual time=19.751..19.751 rows=34,408 loops=3)

  • Output: grid_batch.batch_id, grid_batch.pf_batch_id, grid_batch.biz_unit_id
  • Buckets: 131,072 Batches: 1 Memory Usage: 5,888kB
  • Buffers: shared hit=1,803
  • Worker 0: actual time=19.435..19.436 rows=34,727 loops=1
  • Buffers: shared hit=1,059
  • Worker 1: actual time=19.908..19.908 rows=33,945 loops=1
  • Buffers: shared hit=368
21. 8.682 10.248 ↑ 1.3 34,408 3 / 3

Parallel Bitmap Heap Scan on dbo.grid_batch (cost=3,330.42..39,175.08 rows=43,333 width=20) (actual time=4.877..10.248 rows=34,408 loops=3)

  • Output: grid_batch.batch_id, grid_batch.pf_batch_id, grid_batch.biz_unit_id
  • Recheck Cond: (grid_batch.biz_unit_id = 101,389)
  • Heap Blocks: exact=376
  • Buffers: shared hit=1,803
  • Worker 0: actual time=4.867..10.307 rows=34,727 loops=1
  • Buffers: shared hit=1,059
  • Worker 1: actual time=4.881..10.157 rows=33,945 loops=1
  • Buffers: shared hit=368
22. 1.566 1.566 ↑ 1.0 103,223 1 / 3

Bitmap Index Scan on ix_grid_batch_idx_grid_batch_biz_unit_batch_id (cost=0.00..3,304.42 rows=103,999 width=0) (actual time=4.699..4.699 rows=103,223 loops=1)

  • Index Cond: (grid_batch.biz_unit_id = 101,389)
  • Buffers: shared hit=629
  • Worker 0: actual time=4.699..4.699 rows=103,223 loops=1
  • Buffers: shared hit=629
23. 335.880 620.920 ↑ 1.3 773,294 3 / 3

Parallel Hash (cost=53,574.27..53,574.27 rows=968,581 width=224) (actual time=620.920..620.920 rows=773,294 loops=3)

  • Output: pf.inquiry_id, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, pf.concatname_u, pf.concatname, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, pf.taxid, pf.inquiry_notes, pf.pf_status, pf.look_back, pf.record_in_dt, pf.erase_dt, pf.batch_id
  • Buckets: 16,384 Batches: 256 Memory Usage: 1,728kB
  • Buffers: shared hit=41,467, temp written=28,952
  • Worker 0: actual time=620.767..620.767 rows=775,391 loops=1
  • Buffers: shared hit=13,855, temp written=9,664
  • Worker 1: actual time=620.991..620.992 rows=769,647 loops=1
  • Buffers: shared hit=13,753, temp written=9,608
24. 285.040 285.040 ↑ 1.3 773,294 3 / 3

Parallel Seq Scan on dbo.grid_pf_101389 pf (cost=0.00..53,574.27 rows=968,581 width=224) (actual time=0.012..285.040 rows=773,294 loops=3)

  • Output: pf.inquiry_id, pf.acct_nbr, pf.branch_nbr, pf.user_name, pf.forward_look_process, pf.business_name, pf.first_name, pf.last_name, pf.middle_name, pf.concatname_u, pf.concatname, pf.city_name, pf.province, pf.country, pf.delivery_line, pf.postal_cd, pf.age, pf.dt_of_birth, pf.global_search, pf.taxid, pf.inquiry_notes, pf.pf_status, pf.look_back, pf.record_in_dt, pf.erase_dt, pf.batch_id
  • Filter: ((pf.pf_status)::text <> 'PRG'::text)
  • Rows Removed by Filter: 1,003
  • Buffers: shared hit=41,467
  • Worker 0: actual time=0.012..284.674 rows=775,391 loops=1
  • Buffers: shared hit=13,855
  • Worker 1: actual time=0.012..284.498 rows=769,647 loops=1
  • Buffers: shared hit=13,753
25. 49,130.012 57,379.944 ↑ 1.2 49,283,886 3 / 3

Parallel Hash (cost=1,703,264.27..1,703,264.27 rows=61,603,327 width=16) (actual time=57,379.944..57,379.944 rows=49,283,886 loops=3)

  • Output: gr.response_cd, gr.batch_id, gr.inquiry_id, gr.batch_reset
  • Buckets: 131,072 Batches: 4,096 Memory Usage: 3,072kB
  • Buffers: shared hit=98 read=1,087,133, temp written=750,312
  • I/O Timings: read=2,597.241
  • Worker 0: actual time=57,379.633..57379.633 rows=48,204,036 loops=1
  • Buffers: shared hit=37 read=354,432, temp written=245,672
  • I/O Timings: read=857.864
  • Worker 1: actual time=57,379.991..57379.991 rows=49,002,108 loops=1
  • Buffers: shared hit=32 read=360,310, temp written=245,764
  • I/O Timings: read=855.031
26. 8,249.932 8,249.932 ↑ 1.2 49,283,886 3 / 3

Parallel Seq Scan on dbo.grid_response gr (cost=0.00..1,703,264.27 rows=61,603,327 width=16) (actual time=0.019..8,249.932 rows=49,283,886 loops=3)

  • Output: gr.response_cd, gr.batch_id, gr.inquiry_id, gr.batch_reset
  • Buffers: shared hit=98 read=1,087,133
  • I/O Timings: read=2,597.241
  • Worker 0: actual time=0.019..8122.955 rows=48,204,036 loops=1
  • Buffers: shared hit=37 read=354,432
  • I/O Timings: read=857.864
  • Worker 1: actual time=0.016..8107.017 rows=49,002,108 loops=1
  • Buffers: shared hit=32 read=360,310
  • I/O Timings: read=855.031
Planning time : 1.377 ms
Execution time : 74,125.422 ms