explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iRyJ

Settings
# exclusive inclusive rows x rows loops node
1. 19.328 44.747 ↓ 1.6 74,378 1

Hash Join (cost=13.85..9,226.78 rows=46,072 width=1,137) (actual time=0.107..44.747 rows=74,378 loops=1)

  • Hash Cond: ((f.form_type_id = ftv.form_type_id) AND (f.form_type_version = ftv.version))
2. 25.327 25.327 ↑ 1.0 74,378 1

Seq Scan on forms_history f (cost=0.00..8,818.78 rows=74,378 width=576) (actual time=0.007..25.327 rows=74,378 loops=1)

3. 0.039 0.092 ↑ 1.0 154 1

Hash (cost=11.54..11.54 rows=154 width=45) (actual time=0.092..0.092 rows=154 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
4. 0.053 0.053 ↑ 1.0 154 1

Seq Scan on form_type_versions ftv (cost=0.00..11.54 rows=154 width=45) (actual time=0.005..0.053 rows=154 loops=1)

Planning time : 0.253 ms
Execution time : 46.880 ms