explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jnd6

Settings
# exclusive inclusive rows x rows loops node
1. 0.176 674.509 ↑ 1.0 6 1

Sort (cost=37,458.57..37,458.59 rows=6 width=747) (actual time=674.457..674.509 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: 32kB
2. 0.178 674.333 ↑ 1.0 6 1

Nested Loop Left Join (cost=37,407.30..37,458.49 rows=6 width=747) (actual time=673.721..674.333 rows=6 loops=1)

3. 0.185 674.035 ↑ 1.0 6 1

Nested Loop (cost=37,407.17..37,457.52 rows=6 width=709) (actual time=673.676..674.035 rows=6 loops=1)

4. 0.254 673.664 ↑ 1.0 6 1

HashAggregate (cost=37,406.74..37,406.80 rows=6 width=4) (actual time=673.614..673.664 rows=6 loops=1)

  • Group Key: com_1.id
5. 0.179 673.410 ↑ 1.0 6 1

Limit (cost=0.55..37,406.67 rows=6 width=118) (actual time=134.149..673.410 rows=6 loops=1)

6. 673.231 673.231 ↑ 9.0 6 1

Index Scan using company_sorting on "Companies" com_1 (cost=0.55..336,655.61 rows=54 width=118) (actual time=134.130..673.231 rows=6 loops=1)

  • Filter: ("isLive" AND (("registrationNumber")::text ~~* '%50533%'::text) AND (("issuanceAgency")::text = 'ACRA'::text))
  • Rows Removed by Filter: 153628
7. 0.186 0.186 ↑ 1.0 1 6

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

  • Index Cond: (id = com_1.id)
8. 0.120 0.120 ↑ 1.0 1 6

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

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