explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dIPj

Settings
# exclusive inclusive rows x rows loops node
1. 66.207 25,350.775 ↓ 1.2 84,765 1

Nested Loop (cost=0.56..274,039.09 rows=68,324 width=427) (actual time=0.704..25,350.775 rows=84,765 loops=1)

2. 0.378 1.568 ↑ 1.0 1,000 1

Limit (cost=0.00..22.45 rows=1,000 width=45) (actual time=0.677..1.568 rows=1,000 loops=1)

3. 1.190 1.190 ↑ 62.6 1,000 1

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

4. 25,283.000 25,283.000 ↓ 1.2 85 1,000

Index Scan using enterprises_siren_nic_index on enterprises (cost=0.56..273.33 rows=68 width=392) (actual time=3.724..25.283 rows=85 loops=1,000)

  • Index Cond: (siren = enterprises_in_sample.siren)
Planning time : 0.294 ms
Execution time : 25,357.827 ms