explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m8Lm

Settings
# exclusive inclusive rows x rows loops node
1. 9,715.910 72,875.892 ↑ 116.8 232,064 1

Hash Join (cost=1,640.33..3,006,518.24 rows=27,093,481 width=46) (actual time=2,562.178..72,875.892 rows=232,064 loops=1)

  • Hash Cond: (decision_laws.initial_version = decision_laws_1.initial_version)
2. 63,159.952 63,159.952 ↑ 1.2 49,988,164 1

Seq Scan on decision_laws (cost=0.00..2,542,071.55 rows=61,482,435 width=46) (actual time=0.068..63,159.952 rows=49,988,164 loops=1)

  • Filter: (doc_id <> '00054E5B098520BEC8F7'::text)
  • Rows Removed by Filter: 2
3. 0.004 0.030 ↑ 198.5 2 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 0.006 0.026 ↑ 198.5 2 1

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

  • Group Key: decision_laws_1.initial_version
5. 0.020 0.020 ↑ 204.5 2 1

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 time=0.019..0.020 rows=2 loops=1)

  • Index Cond: (doc_id = '00054E5B098520BEC8F7'::text)
Planning time : 0.591 ms
Execution time : 72,900.751 ms