explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T8c9

Settings
# exclusive inclusive rows x rows loops node
1. 690.637 965.090 ↓ 47,748.0 47,748 1

Sort (cost=17.61..17.62 rows=1 width=585) (actual time=830.964..965.090 rows=47,748 loops=1)

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

Bitmap Heap Scan on "Customers" (cost=13.56..17.60 rows=1 width=585) (actual time=44.482..274.453 rows=47,748 loops=1)

  • Recheck Cond: (("ActiveBankServiceGroups" ?| '{""}'::text[]) AND ("ActiveBankServices" ?| '{""}'::text[]))
  • Filter: ((("Status")::text <> 'Prospective Relationship'::text) AND (("CustomerExclusions")::text <> ALL ('{Reports,"Reports And Communications"}'::text[])) AND (("Status")::text = 'Current Relationship'::text))
  • Rows Removed by Filter: 2252
  • Heap Blocks: exact=6776
3. 0.501 32.988 ↓ 0.0 0 1

BitmapAnd (cost=13.56..13.56 rows=1 width=0) (actual time=32.988..32.988 rows=0 loops=1)

4. 16.921 16.921 ↓ 1,000.0 50,000 1

Bitmap Index Scan on ix_customer_reports_activebankservicegroups (cost=0.00..4.65 rows=50 width=0) (actual time=16.921..16.921 rows=50,000 loops=1)

  • Index Cond: ("ActiveBankServiceGroups" ?| '{""}'::text[])
5. 15.566 15.566 ↓ 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=15.566..15.566 rows=50,000 loops=1)

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