explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5iDv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on listing_to_property (cost=1.68..1,018,953.55 rows=1 width=13) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.68..1,018,953.55 rows=1 width=13) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=1.12..1,018,952.66 rows=1 width=13) (actual rows= loops=)

  • Merge Cond: (l.internal_listing_id = lp2.internal_listing_id)
4. 0.000 0.000 ↓ 0.0

Index Only Scan using level1_listing_pkey on level1_listing l (cost=0.56..436,992.81 rows=11,659,857 width=13) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Only Scan using listing_to_property_internal_listing_id_idx2 on listing_to_property lp2 (cost=0.56..406,932.06 rows=11,711,829 width=13) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using listing_to_property_internal_property_id_idx on listing_to_property lp (cost=0.56..0.77 rows=11 width=13) (actual rows= loops=)

  • Index Cond: (internal_property_id = l.internal_listing_id)