explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tTxW

Settings
# exclusive inclusive rows x rows loops node
1. 833.604 1,053.590 ↓ 50,000.0 50,000 1

Sort (cost=17.60..17.61 rows=1 width=585) (actual time=919.240..1,053.590 rows=50,000 loops=1)

  • Sort Key: "FullName
  • Sort Method: external merge Disk: 30552kB
2. 188.137 219.986 ↓ 50,000.0 50,000 1

Bitmap Heap Scan on "Customers" (cost=13.56..17.59 rows=1 width=585) (actual time=32.913..219.986 rows=50,000 loops=1)

  • Recheck Cond: (("ActiveBankServiceGroups" ?| '{""}'::text[]) AND ("ActiveBankServices" ?| '{""}'::text[]))
  • Heap Blocks: exact=6776
3. 0.495 31.849 ↓ 0.0 0 1

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

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

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

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