explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njq8

Settings
# exclusive inclusive rows x rows loops node
1. 543.303 698.023 ↓ 47,748.0 47,748 1

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

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

Bitmap Heap Scan on "Customers" (cost=13.56..17.60 rows=1 width=585) (actual time=35.185..154.720 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.380 30.799 ↓ 0.0 0 1

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

4. 16.001 16.001 ↓ 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.000..16.001 rows=50,000 loops=1)

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

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