explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yoBY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,189.60..3,052,603.81 rows=4,280,407 width=427) (actual rows= loops=)

  • Hash Cond: (enterprises.siren = enterprises_in_sample.siren)
2. 0.000 0.000 ↓ 0.0

Seq Scan on enterprises (cost=0.00..2,888,220.74 rows=31,837,174 width=392) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=1,406.49..1,406.49 rows=62,649 width=45) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on enterprises_in_sample (cost=0.00..1,406.49 rows=62,649 width=45) (actual rows= loops=)