explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jDHh

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

Merge Join (cost=5,578,329.52..5,769,051.32 rows=129,765 width=108) (actual rows= loops=)

  • Merge Cond: (((i.mrn)::text = x.mrn) AND ((i.oid)::text = x.oid))
  • Join Filter: ((x.mpid)::text <> (i.mpiid)::text)
2. 0.000 0.000 ↓ 0.0

Sort (cost=2,005,842.76..2,035,001.98 rows=11,663,689 width=52) (actual rows= loops=)

  • Sort Key: i.mrn, i.oid
3. 0.000 0.000 ↓ 0.0

Seq Scan on inus_temp i (cost=0.00..238,122.89 rows=11,663,689 width=52) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=3,572,486.76..3,622,486.76 rows=10,000,000 width=176) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=3,572,486.76..3,597,486.76 rows=10,000,000 width=176) (actual rows= loops=)

  • Sort Key: x.mrn, x.oid
6. 0.000 0.000 ↓ 0.0

Subquery Scan on x (cost=0.00..1,555,318.43 rows=10,000,000 width=176) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..1,455,318.43 rows=10,000,000 width=156) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on documententry d (cost=0.00..3,410,166.47 rows=23,432,442 width=156) (actual rows= loops=)