explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hgD1i

Settings
# exclusive inclusive rows x rows loops node
1. 1,207,483.679 3,133,002.823 ↑ 1.1 223,785 1

Nested Loop (cost=0.00..8,812,519.61 rows=234,997 width=186) (actual time=62.306..3,133,002.823 rows=223,785 loops=1)

  • Join Filter: (cn.id = at.id)
  • Rows Removed by Join Filter: 29,335,935,881
  • Buffers: shared read=9,186, temp read=422,638,137 written=5,173
2. 188.723 188.723 ↑ 1.0 234,997 1

Seq Scan on company_name cn (cost=0.00..115.56 rows=234,997 width=75) (actual time=25.670..188.723 rows=234,997 loops=1)

  • Buffers: shared read=2,994
3. 1,925,174.194 1,925,330.421 ↑ 2.9 124,836 234,997

Materialize (cost=0.00..256.38 rows=361,472 width=111) (actual time=0.002..8.193 rows=124,836 loops=234,997)

  • Buffers: shared read=6,192, temp read=422,638,137 written=5,173
4. 156.227 156.227 ↑ 1.0 361,472 1

Seq Scan on aka_title at (cost=0.00..233.84 rows=361,472 width=111) (actual time=7.323..156.227 rows=361,472 loops=1)

  • Buffers: shared read=6,192