explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oFBi

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 23.633 ↑ 1.0 50 1

Limit (cost=0.56..113.48 rows=50 width=427) (actual time=2.741..23.633 rows=50 loops=1)

2. 0.048 23.624 ↑ 85,608.1 50 1

Nested Loop (cost=0.56..9,666,439.50 rows=4,280,407 width=427) (actual time=2.740..23.624 rows=50 loops=1)

3. 0.905 0.905 ↑ 20,883.0 3 1

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

4. 22.671 22.671 ↑ 4.0 17 3

Index Scan using enterprises_siren_nic_index on enterprises (cost=0.56..153.59 rows=68 width=392) (actual time=2.796..7.557 rows=17 loops=3)

  • Index Cond: (siren = enterprises_in_sample.siren)
Planning time : 0.602 ms
Execution time : 23.694 ms