explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zG2f

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

Hash Join (cost=409,280.59..1,424,608.97 rows=5,605,187 width=54) (actual rows= loops=)

  • Hash Cond: ((b.registryobject)::text = (a.id)::text)
2. 0.000 0.000 ↓ 0.0

Seq Scan on externalidentifier b (cost=0.00..891,781.90 rows=2,766,418 width=100) (actual rows= loops=)

  • Filter: ((identificationscheme)::text = 'urn:uuid:58a6f841-87b3-4a3e-92fd-a8ffeff98427'::text)
3. 0.000 0.000 ↓ 0.0

Hash (cost=387,548.59..387,548.59 rows=800,480 width=92) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=129,835.10..387,548.59 rows=800,480 width=92) (actual rows= loops=)

  • Hash Cond: ((c.parent)::text = (a.id)::text)
5. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_slot_name_parent_value on slot c (cost=0.00..184,840.30 rows=2,243,919 width=46) (actual rows= loops=)

  • Index Cond: ((name_ = 'creationTime'::text) AND (value >= '20200728'::text))
6. 0.000 0.000 ↓ 0.0

Hash (cost=109,016.51..109,016.51 rows=977,887 width=46) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_extrinsicobject_status_id on extrinsicobject a (cost=0.00..109,016.51 rows=977,887 width=46) (actual rows= loops=)

  • Index Cond: (status = 'urn:oasis:names:tc:ebxml-regrep:StatusType:Approved'::text)