explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bDYl

Settings
# exclusive inclusive rows x rows loops node
1. 0.179 718.511 ↑ 1.0 6 1

Limit (cost=83,256.18..83,256.20 rows=6 width=747) (actual time=718.296..718.511 rows=6 loops=1)

2. 0.180 718.332 ↑ 1.0 6 1

Sort (cost=83,256.18..83,256.20 rows=6 width=747) (actual time=718.283..718.332 rows=6 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: 33kB
3. 0.152 718.152 ↑ 1.0 6 1

Nested Loop Left Join (cost=83,204.91..83,256.10 rows=6 width=747) (actual time=717.591..718.152 rows=6 loops=1)

4. 0.149 717.844 ↑ 1.0 6 1

Nested Loop (cost=83,204.78..83,255.13 rows=6 width=709) (actual time=717.560..717.844 rows=6 loops=1)

5. 0.090 717.569 ↑ 1.0 6 1

HashAggregate (cost=83,204.35..83,204.41 rows=6 width=4) (actual time=717.521..717.569 rows=6 loops=1)

  • Group Key: com_1.id
6. 0.098 717.479 ↑ 1.0 6 1

Limit (cost=83,204.26..83,204.28 rows=6 width=118) (actual time=717.345..717.479 rows=6 loops=1)

7. 20.389 717.381 ↑ 9.0 6 1

Sort (cost=83,204.26..83,204.40 rows=54 width=118) (actual time=717.331..717.381 rows=6 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: top-N heapsort Memory: 26kB
8. 696.992 696.992 ↓ 48.4 2,616 1

Seq Scan on "Companies" com_1 (cost=0.00..83,203.29 rows=54 width=118) (actual time=0.107..696.992 rows=2,616 loops=1)

  • Filter: ("isLive" AND (("registrationNumber")::text ~~* '%503%'::text) AND (("issuanceAgency")::text = 'ACRA'::text))
  • Rows Removed by Filter: 556537
9. 0.126 0.126 ↑ 1.0 1 6

Index Scan using "PK_999ff985663bc48d13b08bce475" on "Companies" com (cost=0.42..8.44 rows=1 width=709) (actual time=0.012..0.021 rows=1 loops=6)

  • Index Cond: (id = com_1.id)
10. 0.156 0.156 ↑ 1.0 1 6

Index Scan using "PK_5523697543970f7c5df2b0adb1b" on "EntityTypes" et (cost=0.14..0.15 rows=1 width=36) (actual time=0.018..0.026 rows=1 loops=6)

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