explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3NEv

Settings
# exclusive inclusive rows x rows loops node
1. 5.589 77.193 ↓ 0.0 18,576 1

Nested loop inner join (cost=6335.60 rows=4698) (cost=0..0 rows=0 width=0) (actual time=0.200..77.193 rows=18,576 loops=1)

2. 5.044 34.452 ↓ 0.0 18,576 1

Filter: (external_ids.internal_type = 'Accommodation') (cost=1686.32 rows=4698) (cost=0..0 rows=0 width=0) (actual time=0.181..34.452 rows=18,576 loops=1)

3. 29.408 29.408 ↓ 0.0 24,342 1

Index lookup on external_ids using external_ids_channel_manager_id_foreign (channel_manager_id=1) (cost=1686.32 rows=46982) (cost=0..0 rows=0 width=0) (actual time=0.162..29.408 rows=24,342 loops=1)

4. 37.152 37.152 ↓ 0.0 1 18,576

Single-row index lookup on accommodations using PRIMARY (id=external_ids.internal_id) (cost=0.89 rows=1) (cost=0..0 rows=0 width=0) (actual time=0.002..0.002 rows=1 loops=18,576)