explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EESq

Settings
# exclusive inclusive rows x rows loops node
1. 0.789 26,130.206 ↑ 1.0 25 1

Limit (cost=936,644.71..936,644.78 rows=25 width=376) (actual time=26,129.224..26,130.206 rows=25 loops=1)

2. 2.292 26,129.417 ↑ 1.0 25 1

Sort (cost=936,644.71..936,644.78 rows=25 width=376) (actual time=26,129.207..26,129.417 rows=25 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: 37kB
3. 0.811 26,127.125 ↑ 1.0 25 1

Hash Left Join (cost=936,436.60..936,644.13 rows=25 width=376) (actual time=26,121.420..26,127.125 rows=25 loops=1)

  • Hash Cond: (com."entityTypeId" = et.id)
4. 1.471 26,125.499 ↑ 1.0 25 1

Nested Loop (cost=936,435.31..936,642.51 rows=25 width=338) (actual time=26,120.552..26,125.499 rows=25 loops=1)

5. 1.796 26,119.103 ↑ 1.0 25 1

HashAggregate (cost=936,430.87..936,431.12 rows=25 width=4) (actual time=26,118.861..26,119.103 rows=25 loops=1)

  • Group Key: com_1.id
6. 0.769 26,117.307 ↑ 1.0 25 1

Limit (cost=936,430.50..936,430.56 rows=25 width=118) (actual time=26,116.294..26,117.307 rows=25 loops=1)

7. 4,551.880 26,116.538 ↑ 21,711.5 25 1

Sort (cost=936,430.50..937,787.47 rows=542,788 width=118) (actual time=26,116.279..26,116.538 rows=25 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: 31kB
8. 21,564.658 21,564.658 ↓ 1.0 544,168 1

Seq Scan on "Companies" com_1 (cost=0.00..921,113.41 rows=542,788 width=118) (actual time=1.060..21,564.658 rows=544,168 loops=1)

  • Filter: (("issuanceAgency")::text = 'ACRA'::text)
  • Rows Removed by Filter: 14985
9. 4.275 4.925 ↑ 1.0 1 25

Bitmap Heap Scan on "Companies" com (cost=4.43..8.45 rows=1 width=338) (actual time=0.185..0.197 rows=1 loops=25)

  • Recheck Cond: (id = com_1.id)
  • Heap Blocks: exact=25
10. 0.650 0.650 ↑ 1.0 1 25

Bitmap Index Scan on "PK_999ff985663bc48d13b08bce475" (cost=0.00..4.43 rows=1 width=0) (actual time=0.022..0.026 rows=1 loops=25)

  • Index Cond: (id = com_1.id)
11. 0.311 0.815 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=36) (actual time=0.800..0.815 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.504 0.504 ↑ 1.0 13 1

Seq Scan on "EntityTypes" et (cost=0.00..1.13 rows=13 width=36) (actual time=0.050..0.504 rows=13 loops=1)

Planning time : 44.493 ms
Execution time : 26,148.971 ms