explain.depesz.com

PostgreSQL's explain analyze made readable

Result: en5Dv

Settings
# exclusive inclusive rows x rows loops node
1. 4.955 95,171.075 ↓ 2.1 9,886 1

Limit (cost=669,647,931.08..670,584,017.87 rows=4,752 width=181) (actual time=93,446.424..95,171.075 rows=9,886 loops=1)

2. 1,714.626 95,166.120 ↓ 2.1 9,886 1

Result (cost=669,647,931.08..670,584,017.87 rows=4,752 width=181) (actual time=93,446.422..95,166.120 rows=9,886 loops=1)

3. 30.293 93,451.494 ↓ 2.1 9,886 1

Sort (cost=669,647,931.08..669,647,942.96 rows=4,752 width=189) (actual time=93,445.134..93,451.494 rows=9,886 loops=1)

  • Sort Key: a1.id
  • Sort Method: external merge Disk: 4,736kB
4. 74.119 93,421.201 ↓ 2.1 9,886 1

Nested Loop Left Join (cost=12,810.62..669,647,640.87 rows=4,752 width=189) (actual time=271.976..93,421.201 rows=9,886 loops=1)

  • Filter: (a3.archive_on IS NULL)
  • Rows Removed by Filter: 4
5. 93,347.082 93,347.082 ↓ 1.6 9,890 1

Hash Left Join (cost=12,810.05..669,600,700.04 rows=6,165 width=531) (actual time=271.966..93,347.082 rows=9,890 loops=1)

  • Hash Cond: (a1.id = a2.private_company_id)