explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kVB3

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

Nested Loop (cost=1,367.55..1,423.09 rows=1 width=377) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,367.12..1,412.80 rows=8 width=16) (actual rows= loops=)

  • Hash Cond: ((om_form.form_template_fk = f.form_template_fk) AND ((max(om_form.date_upd_fields)) = f.date_upd_fields))
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=581.85..598.43 rows=1,658 width=24) (actual rows= loops=)

  • Group Key: om_form.form_template_fk, om_form.order_item_fk
4. 0.000 0.000 ↓ 0.0

Seq Scan on om_form (cost=0.00..569.14 rows=1,695 width=24) (actual rows= loops=)

  • Filter: ((reference_key)::text = ''FORMSEO''::text)
5. 0.000 0.000 ↓ 0.0

Hash (cost=525.91..525.91 rows=17,291 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on om_form f (cost=0.00..525.91 rows=17,291 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using om_form_field_form_fk_idx on om_form_field ff (cost=0.42..1.28 rows=1 width=369) (actual rows= loops=)

  • Index Cond: (form_fk = f.id)
  • Filter: ((reference_key)::text = ''GEPFLEGTVON''::text)