explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fq4h

Settings
# exclusive inclusive rows x rows loops node
1. 207,022.552 207,174.967 ↓ 1.6 74,378 1

Hash Join (cost=13.85..20,744.78 rows=46,072 width=588) (actual time=3.385..207,174.967 rows=74,378 loops=1)

  • Hash Cond: ((f.form_type_id = ftv.form_type_id) AND (f.form_type_version = ftv.version))
2. 152.323 152.323 ↑ 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.006..152.323 rows=74,378 loops=1)

3. 0.044 0.092 ↑ 1.0 154 1

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

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

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

Planning time : 0.244 ms
Execution time : 207,205.289 ms