explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uK40

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 853.654 ↓ 0.0 191,717 1

Nested loop inner join (cost=37724.61 rows=18757) (cost=0..0 rows=0 width=0) (actual time=0.067..853.654 rows=191,717 loops=1)

2. 39.403 134.676 ↓ 0.0 191,717 1

Filter: (external_ids.internal_type = 'Accommodation') (cost=19162.70 rows=18757) (cost=0..0 rows=0 width=0) (actual time=0.050..134.676 rows=191,717 loops=1)

3. 95.273 95.273 ↓ 0.0 197,507 1

Table scan on external_ids (cost=19162.70 rows=187572) (cost=0..0 rows=0 width=0) (actual time=0.036..95.273 rows=197,507 loops=1)

4. 766.868 766.868 ↓ 0.0 1 191,717

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.004..0.004 rows=1 loops=191,717)