explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Upc9s

Settings
# exclusive inclusive rows x rows loops node
1. 2.348 71.316 ↓ 0.0 18,576 1

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

2. 4.912 31.816 ↓ 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.113..31.816 rows=18,576 loops=1)

3. 26.904 26.904 ↓ 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.103..26.904 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)