explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FJJO

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

Hash Join (cost=696.35..2,203.84 rows=1,341 width=1,248) (actual rows= loops=)

  • Hash Cond: (o_1.status_pk = mod_status_1.status_pk)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=693.82..2,197.57 rows=1,341 width=1,220) (actual rows= loops=)

  • Hash Cond: (o_1.object_type_pk = ot_1.object_type_pk)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=686.29..2,186.30 rows=1,341 width=1,169) (actual rows= loops=)

  • Hash Cond: (((o_1.object_pk)::character varying)::text = (o.header_attr_code_2)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on mod_object o_1 (cost=0.00..648.44 rows=9,444 width=545) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=684.56..684.56 rows=139 width=624) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=9.39..684.56 rows=139 width=624) (actual rows= loops=)

  • Hash Cond: (o.status_pk = mod_status.status_pk)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=6.86..681.64 rows=139 width=596) (actual rows= loops=)

  • Hash Cond: (o.object_type_pk = ot.object_type_pk)
8. 0.000 0.000 ↓ 0.0

Seq Scan on mod_object o (cost=0.00..648.44 rows=9,444 width=545) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=6.85..6.85 rows=1 width=59) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on mod_object_type ot (cost=0.00..6.85 rows=1 width=59) (actual rows= loops=)

  • Filter: ((object_type_code)::text = 'PROJECT'::text)
11. 0.000 0.000 ↓ 0.0

Hash (cost=1.68..1.68 rows=68 width=36) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on mod_status (cost=0.00..1.68 rows=68 width=36) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=6.68..6.68 rows=68 width=59) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on mod_object_type ot_1 (cost=0.00..6.68 rows=68 width=59) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=1.68..1.68 rows=68 width=36) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on mod_status mod_status_1 (cost=0.00..1.68 rows=68 width=36) (actual rows= loops=)