explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lDlW

Settings
# exclusive inclusive rows x rows loops node
1. 996.862 1,497.774 ↓ 47,748.0 47,748 1

Sort (cost=204.23..204.23 rows=1 width=585) (actual time=1,384.906..1,497.774 rows=47,748 loops=1)

  • Sort Key: "FullName
  • Sort Method: external merge Disk: 29168kB
2. 478.569 500.912 ↓ 47,748.0 47,748 1

Bitmap Heap Scan on "Customers" (cost=8.65..204.22 rows=1 width=585) (actual time=28.262..500.912 rows=47,748 loops=1)

  • Recheck Cond: ("ActiveBankServices" ?| '{""}'::text[])
  • Filter: (("ActiveBankServiceGroups" ?| '{""}'::text[]) AND (("Status")::text <> 'Prospective Relationship'::text) AND (("CustomerExclusions")::text <> ALL ('{Reports,"Reports And Communications"}'::text[])) AND ("BankId" = 1) AND (("Status")::text = 'Current Relationship'::text) AND ((('{""}'::text[])[1] = ''::text) OR (("RegionId")::text = ANY ('{""}'::text[]))) AND ((('{""}'::text[])[1] = ''::text) OR (("BranchId")::text = ANY ('{""}'::text[]))) AND ((('{""}'::text[])[1] = ''::text) OR (("BankerId")::text = ANY ('{""}'::text[]))))
  • Rows Removed by Filter: 2252
  • Heap Blocks: exact=6776
3. 22.343 22.343 ↓ 1,000.0 50,000 1

Bitmap Index Scan on ix_reports_customers_activebankservices (cost=0.00..8.65 rows=50 width=0) (actual time=22.343..22.343 rows=50,000 loops=1)

  • Index Cond: ("ActiveBankServices" ?| '{""}'::text[])