explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yvoj

Settings
# exclusive inclusive rows x rows loops node
1. 0.100 30.780 ↓ 0.0 0 1

Sort (cost=23,206.91..23,206.91 rows=1 width=747) (actual time=30.773..30.780 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
  • (((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 ~~* '% 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.015 30.680 ↓ 0.0 0 1

Nested Loop Left Join (cost=23,198.83..23,206.90 rows=1 width=747) (actual time=30.673..30.680 rows=0 loops=1)

3. 0.014 30.665 ↓ 0.0 0 1

Nested Loop (cost=23,198.70..23,206.74 rows=1 width=709) (actual time=30.659..30.665 rows=0 loops=1)

4. 0.014 30.651 ↓ 0.0 0 1

HashAggregate (cost=23,198.27..23,198.28 rows=1 width=4) (actual time=30.645..30.651 rows=0 loops=1)

  • Group Key: com_1.id
5. 0.013 30.637 ↓ 0.0 0 1

Limit (cost=23,198.26..23,198.26 rows=1 width=118) (actual time=30.630..30.637 rows=0 loops=1)

6. 0.039 30.624 ↓ 0.0 0 1

Sort (cost=23,198.26..23,198.26 rows=1 width=118) (actual time=30.617..30.624 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. 0.048 30.585 ↓ 0.0 0 1

Bitmap Heap Scan on "Companies" com_1 (cost=2,905.41..23,198.25 rows=1 width=118) (actual time=30.579..30.585 rows=0 loops=1)

  • Recheck Cond: (("totalCapital" IS NOT NULL) AND ("totalCapital" > '9003'::double precision) AND ("totalCapital" < '17609'::double precision) AND ("entityTypeId" = ANY ('{10,1,11}'::integer[])))
  • Filter: ("isLive" AND ("shareCapDelta" > '-8843'::double precision) AND (("issuanceAgency")::text = 'ACRA'::text) 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
8. 3.371 30.537 ↓ 0.0 0 1

BitmapAnd (cost=2,905.41..2,905.41 rows=6,023 width=0) (actual time=30.531..30.537 rows=0 loops=1)

9. 6.358 6.358 ↓ 1.1 28,078 1

Bitmap Index Scan on "IDX_d8658c3b903591fb8638f39070" (cost=0.00..598.12 rows=25,416 width=0) (actual time=6.351..6.358 rows=28,078 loops=1)

  • Index Cond: (("totalCapital" IS NOT NULL) AND ("totalCapital" > '9003'::double precision) AND ("totalCapital" < '17609'::double precision))
10. 20.808 20.808 ↑ 1.0 128,106 1

Bitmap Index Scan on "IDX_5f45099075d0ec7a4cb2da88bf" (cost=0.00..2,307.03 rows=132,501 width=0) (actual time=20.801..20.808 rows=128,106 loops=1)

  • Index Cond: ("entityTypeId" = ANY ('{10,1,11}'::integer[]))
11. 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)
12. 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)