explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xNHz

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

Hash Join (cost=1,640.33..3,006,518.24 rows=27,093,481 width=46) (actual rows= loops=)

  • Hash Cond: (decision_laws.initial_version = decision_laws_1.initial_version)
2. 0.000 0.000 ↓ 0.0

Seq Scan on decision_laws (cost=0.00..2,542,071.55 rows=61,482,435 width=46) (actual rows= loops=)

  • Filter: (doc_id <> '00054E5B098520BEC8F7'::text)
3. 0.000 0.000 ↓ 0.0

Hash (cost=1,635.36..1,635.36 rows=397 width=20) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,631.39..1,635.36 rows=397 width=20) (actual rows= loops=)

  • Group Key: decision_laws_1.initial_version
5. 0.000 0.000 ↓ 0.0

Index Scan using decision_laws_doc_id_idx on decision_laws decision_laws_1 (cost=0.56..1,630.37 rows=409 width=20) (actual rows= loops=)

  • Index Cond: (doc_id = '00054E5B098520BEC8F7'::text)