explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uMFl

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 3,155.360 ↑ 1.0 50 1

Limit (cost=1.14..4,726.91 rows=50 width=660) (actual time=3,154.213..3,155.360 rows=50 loops=1)

2. 0.059 3,155.348 ↑ 932.1 50 1

Nested Loop Left Join (cost=1.14..4,404,804.98 rows=46,604 width=660) (actual time=3,154.211..3,155.348 rows=50 loops=1)

3. 3,154.189 3,154.189 ↑ 932.1 50 1

Index Scan using i_iws_pc_src_lei_flg_newer on dist_inv_workflow_states diws (cost=0.57..4,282,398.83 rows=46,604 width=71) (actual time=3,154.162..3,154.189 rows=50 loops=1)

  • Index Cond: (legal_entity_id = ANY ('{101,102,103}'::bigint[]))
  • Filter: ((primary_vendor_code)::text = ANY ('{RANDO,BTDS,DENDO,ANQAB,NEWQ1,1UGLV,MHILL}'::text[]))
  • Rows Removed by Filter: 4585041
4. 1.100 1.100 ↑ 1.0 1 50

Index Scan using uniq_distributor_invoice on distributor_invoices di (cost=0.57..2.62 rows=1 width=613) (actual time=0.016..0.022 rows=1 loops=50)

  • Index Cond: (((diws.vendor_invoice_number)::text = (vendor_invoice_number)::text) AND (diws.legal_entity_id = legal_entity_id))
  • Filter: ((diws.primary_vendor_code)::text = btrim((primary_vendor_code)::text))
  • Rows Removed by Filter: 6
Planning time : 0.690 ms