explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z1p6

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

Aggregate (cost=19,121,581.34..19,121,581.35 rows=1 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.58..19,121,459.77 rows=48,628 width=0) (actual rows= loops=)

  • Join Filter: (("Extent2".application_id = "Extent1".application_id) OR (("Extent2".application_id IS NULL) AND ("Extent1".application_id IS NULL)))
3. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_applicationid on card "Extent1" (cost=0.29..1,760.78 rows=67,499 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.29..2,098.27 rows=67,499 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_applicationid on card "Extent2" (cost=0.29..1,760.78 rows=67,499 width=4) (actual rows= loops=)