explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XZa3

Settings
# exclusive inclusive rows x rows loops node
1. 0.156 219.676 ↓ 0.0 0 1

Sort (cost=89,819.21..89,819.22 rows=1 width=747) (actual time=219.669..219.676 rows=0 loops=1)

  • Sort Key: ((com."mpIndex" IS NULL)), ((com."contactNum" IS NULL)), ((com.email IS NULL)), ((com.url IS NULL)), ((com."numberOfStaff" IS NULL)), ((com."shareCapDelta" IS
  • NULL)), com."mpIndex" DESC NULLS LAST, com."contactNum", com.email, com.url, com."numberOfStaff", com."hasEmails", com."shareCapDelta", com."fullName
  • Sort Method: quicksort Memory: 25kB
  • ty %'::text) OR ((address)::text ~~* '% ty'::text)) AND (((address)::text ~~* 'vnt %'::text) OR ((address)::text ~~* '% vnt %'::text) OR ((address)::text ~~* '% vnt'::text)) AND (((address)::text ~~* 'dsvox %'::text) OR ((address)::text ~~* '% dsvox %'::text) OR ((address)::text ~~* '% dsvox'::text)) AND (((address)::text ~~* 'hh %'::text)
  • OR ((address)::text ~~* '% hh %'::text) OR ((address)::text ~~* '% hh'::text)) AND (((address)::text ~~* 'zalol %'::text) OR ((address)::text ~~* '% zalol %'::text) OR ((address)::text ~~* '% zalol'::text)) AND (((address)::text ~~* 'gy %'::text) OR ((address)::text ~~* '% gy %'::text) OR ((address)::text ~~* '% gy'::text)) AND ((("primarySsicCode")::text ~~ '97001%'::text) OR (("primarySsicCode")::text ~~ '28224%'::text) OR (("primarySsicCode")::text ~~ '12001%'::text) OR (("primarySsicCode")::text ~~ '47536%'::text) OR (("primarySsicCode")::text ~~ '322%'::text) OR (("primarySsicCode")::text ~~ '105%'::text) OR (("primarySsicCode")::text ~~ '43220%'::text) OR (("primarySsicCode")::text ~~ '38309%'::text) OR (("primarySsicCode")::text ~~ '32909%'::text) OR (("primarySsicCode")::text ~~ '46434%'::text) OR (("primarySsicCode")::text ~~ '88991%'::text) OR (("primarySsicCode")::text ~~ '96024%'::text) OR (("primarySsicCode")::text ~~ '433%'::text) OR (("primarySsicCode")::text ~~ '27329%'::text) OR (("primarySsicCode")::text ~~ '551%'::text) OR (("primarySsicCode")::text ~~ '75000%'::text) OR (("primarySsicCode")::text ~~ '62019%'::text) OR (("primarySsicCode")::text ~~ '16292%'::text) OR (("primarySsicCode")::text ~~ '71124%'::text) OR (("primarySsicCode")::text ~~ '25111%'::text) OR (("primarySsicCode")::text ~~ '1075%'::text) OR (("primarySsicCode")::text ~~ '26122%'::text) OR (("primarySsicCode")::text ~~ '47313%'::text) OR (("primarySsicCode")::text ~~ '7734%'::text) OR (("primarySsicCode")::text ~~ '21013%'::text) OR (("primarySsicCode")::text ~~ '77341%'::text) OR (("primarySsicCode")::text ~~ '25952%'::text) OR (("primarySsicCode")::text ~~ '68101%'::text) OR (("primarySsicCode")::text ~~ '66124%'::text) OR (("primarySsicCode")::text ~~ '25932%'::text) OR (("primarySsicCode")::text ~~ '64993%'::text) OR (("primarySsicCode")::text ~~ '812%'::text) OR (("primarySsicCode")::text ~~ '652%'::text) OR (("primarySsicCode")::text ~~ '77109%'::text) OR (("primarySsicCode")::text ~~ '46437%'::text) OR (("primarySsicCode")::text ~~ '01411%'::text) OR (("primarySsicCode")::text ~~ '10799%'::text) OR (("primarySsicCode")::text ~~ '56130%'::text) OR (("primarySsicCode")::text ~~ '20242%'::text) OR (("primarySsicCode")::text ~~ '10503%'::text) OR (("primarySsicCode")::text ~~ '9499%'::text) OR (("primarySsicCode")::text ~~ '90001%'::text) OR (("primarySsicCode")::text ~~ '60200%'::text) OR (("primarySsicCode")::text ~~ '64122%'::text) OR (("primarySsicCode")::text ~~ '66292%'::text) OR (("primarySsicCode")::text ~~ '66221%'::text)))
2. 0.013 219.520 ↓ 0.0 0 1

Nested Loop Left Join (cost=89,811.14..89,819.20 rows=1 width=747) (actual time=219.514..219.520 rows=0 loops=1)

3. 0.013 219.507 ↓ 0.0 0 1

Nested Loop (cost=89,811.00..89,819.04 rows=1 width=709) (actual time=219.500..219.507 rows=0 loops=1)

4. 0.014 219.494 ↓ 0.0 0 1

HashAggregate (cost=89,810.58..89,810.59 rows=1 width=4) (actual time=219.487..219.494 rows=0 loops=1)

  • Group Key: com_1.id
5. 0.016 219.480 ↓ 0.0 0 1

Limit (cost=89,810.56..89,810.57 rows=1 width=118) (actual time=219.473..219.480 rows=0 loops=1)

6. 0.037 219.464 ↓ 0.0 0 1

Sort (cost=89,810.56..89,810.57 rows=1 width=118) (actual time=219.457..219.464 rows=0 loops=1)

  • Sort Key: ((com_1."mpIndex" IS NULL)), ((com_1."contactNum" IS NULL)), ((com_1.email IS NULL)), ((com_1.url IS NULL)), ((com_1."numberOfStaff" IS NULL)), ((com_1."shareCapDelta" IS NULL)), com_1."mpIndex" DESC NULLS LAST, com_1."contactNum", com_1.email, com_1.url, com_1."numberOfStaff", com_1."hasEmails", com_1."shareCapDelta", com_1."fullName
  • Sort Method: quicksort Memory: 25kB
7. 150.970 219.427 ↓ 0.0 0 1

Bitmap Heap Scan on "Companies" com_1 (cost=34,139.85..89,810.55 rows=1 width=118) (actual time=219.421..219.427 rows=0 loops=1)

  • Recheck Cond: (("totalCapital" IS NOT NULL) AND ("totalCapital" > '9003'::double precision) AND ("totalCapital" < '17609'::double precision) AND ("shareCapDelta" > '-8843'::double precision))
  • Filter: ("isLive" AND (("issuanceAgency")::text = 'ACRA'::text) AND ("entityTypeId" = ANY ('{10,1,11}'::integer[])) AND ((("numberOfStaff" IS NOT NULL) AND (("numberOfStaff")::text = '51-200'::text)) OR (("numberOfStaff" IS NULL) AND ("numberOfStaffModelled" IS NOT NULL) AND (("numberOfStaffModelled")::text = '51-200'::text))) AND (("businessActivity" ~* '.*\ynbqcrx\y.*'::text) OR (("primaryDescribedActivity")::text ~* '.*\ynbqcrx\y.*'::text) OR (("primarySsicDescription")::text ~* '.*\ynbqcrx\y.*'::text)) AND (((address)::text ~~* 'cl %'::text) OR ((address)::text ~~* '% cl %'::text) OR ((address)::text ~~* '% cl'::text)) AND (((address)::text ~~* 'eassu %'::text) OR ((address)::text ~~* '% eassu %'::text) OR ((address)::text ~~* '% eassu'::text)) AND (((address)::text ~~* 'nnuef %'::text) OR ((address)::text ~~* '% nnuef %'::text) OR ((address)::text ~~* '% nnuef'::text)) AND (((address)::text ~~* 'ljqk %'::text) OR ((address)::text ~~* '% ljqk %'::text) OR ((address)::text ~~* '% ljqk'::text)) AND (((address)::text ~~* 'qokdf %'::text) OR ((address)::text ~~* '% qokdf %'::text) OR ((address)::text ~~* '% qokdf'::text)) AND (((address)::text ~~* 'phjfx %'::text) OR ((address)::text ~~* '% phjfx %'::text) OR ((address)::text ~~* '% phjfx'::text)) AND (((address)::text ~~* 'vcugd %'::text) OR ((address)::text ~~* '% vcugd %'::text) OR ((address)::text ~~* '% vcugd'::text)) AND (((address)::text ~~* 'hum %'::text) OR ((address)::text ~~* '% hum %'::text) OR ((address)::text ~~* '% hum'::text)) AND (((address)::text ~~* 'oolk %'::text) OR ((address)::text ~~* '% oolk %'::text) OR ((address)::text ~~* '% oolk'::text)) AND (((address)::text ~~* 'vugb %'::text) OR ((address)::text ~~* '% vugb %'::text) OR ((address)::text ~~* '% vugb'::text)) AND (((address)::text ~~* 'wq %'::text) OR ((address)::text ~~* '% wq %'::text) OR ((address)::text ~~* '% wq'::text)) AND (((address)::text ~~* 'dhxl %'::text) OR ((address)::text ~~* '% dhxl %'::text) OR ((address)::text ~~* '% dhxl'::text)) AND (((address)::text ~~* 'rok %'::text) OR ((address)::text ~~* '% rok %'::text) OR ((address)::text ~~* '% rok'::text)) AND (((address)::text ~~* 'lyd %'::text) OR ((address)::text ~~* '% lyd %'::text) OR ((address)::text ~~* '% lyd'::text)) AND (((address)::text ~~* 'fnnl %'::text) OR ((address)::text ~~* '% fnnl %'::text) OR ((address)::text ~~* '% fnnl'::text)) AND (((address)::text ~~* 'mhgc %'::text) OR ((address)::text ~~* '% mhgc %'::text) OR ((address)::text ~~* '% mhgc'::text)) AND (((address)::text ~~* 'zpaa %'::text) OR ((address)::text ~~* '% zpaa %'::text) OR ((address)::text ~~* '% zpaa'::text)) AND (((address)::text ~~* 'ty %'::text) OR ((address)::text ~~* '%
  • Rows Removed by Filter: 27509
  • Heap Blocks: exact=21955
8. 68.457 68.457 ↓ 1.2 27,509 1

Bitmap Index Scan on "IDX_675561083307ff2d798a45649d" (cost=0.00..34,139.85 rows=22,559 width=0) (actual time=68.450..68.457 rows=27,509 loops=1)

  • Index Cond: (("totalCapital" IS NOT NULL) AND ("totalCapital" > '9003'::double precision) AND ("totalCapital" < '17609'::double precision) AND ("shareCapDelta" > '-8843'::double precision))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_999ff985663bc48d13b08bce475" on "Companies" com (cost=0.42..8.44 rows=1 width=709) (never executed)

  • Index Cond: (id = com_1.id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_5523697543970f7c5df2b0adb1b" on "EntityTypes" et (cost=0.14..0.15 rows=1 width=36) (never executed)

  • Index Cond: (com."entityTypeId" = id)