explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NHoX

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

Update on person t (cost=299,333.71..390,714.21 rows=2,434 width=215) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=299,333.71..390,714.21 rows=2,434 width=215) (actual rows= loops=)

  • Hash Cond: (((c.vocabulary_id)::text = (cs.vocabulary_id)::text) AND (t.gender_source_code_system = cs.code_system))
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=299,308.71..388,130.36 rows=487,391 width=218) (actual rows= loops=)

  • Hash Cond: ((t.gender_source_value)::text = (c.concept_code)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on person t (cost=0.00..15,493.87 rows=404,687 width=199) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=179,731.65..179,731.65 rows=6,184,165 width=31) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on concept c (cost=0.00..179,731.65 rows=6,184,165 width=31) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=16.00..16.00 rows=600 width=96) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on ccd_code_system_map cs (cost=0.00..16.00 rows=600 width=96) (actual rows= loops=)