explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e7x

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

Nested Loop Left Join (cost=127.56..3,543.78 rows=58 width=1,314) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=122.83..1,375.36 rows=58 width=1,250) (actual rows= loops=)

  • Hash Cond: (d.doc_class = dc.key)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=27.75..1,279.36 rows=58 width=662) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=27.47..176.43 rows=1 width=134) (actual rows= loops=)

  • Join Filter: ((t.alias)::text = ((m.alias)::text))
5. 0.000 0.000 ↓ 0.0

Seq Scan on d_ref_document_type t (cost=0.00..147.50 rows=1 width=134) (actual rows= loops=)

  • Filter: ((key = master_key) AND (is_draft = 0) AND (sys_status = 0))
6. 0.000 0.000 ↓ 0.0

Unique (cost=27.47..27.51 rows=2 width=218) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Sort (cost=27.47..27.49 rows=8 width=218) (actual rows= loops=)

  • Sort Key: ((m.alias)::text)
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mv_logical_view_items m (cost=4.34..27.35 rows=8 width=218) (actual rows= loops=)

  • Recheck Cond: ((lv_alias)::text = 'IsogdAllDocNoReg'::text)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mv_logical_view_items_idx (cost=0.00..4.34 rows=8 width=0) (actual rows= loops=)

  • Index Cond: ((lv_alias)::text = 'IsogdAllDocNoReg'::text)
10. 0.000 0.000 ↓ 0.0

Index Scan using t_d_document_document_type_key_fk_idx on d_document d (cost=0.29..933.24 rows=239 width=552) (actual rows= loops=)

  • Index Cond: (document_type_key = t.key)
  • Filter: ((date_reg_doc IS NULL) AND (isogd_not_subject IS NULL) AND (is_draft = 0) AND (sys_status = 0))
11. 0.000 0.000 ↓ 0.0

Hash (cost=94.36..94.36 rows=1 width=604) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..94.36 rows=1 width=604) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on d_ref_doc_class dc (cost=0.00..84.64 rows=1 width=532) (actual rows= loops=)

  • Filter: ((key = master_key) AND (is_draft = 0) AND (sys_status = 0))
14. 0.000 0.000 ↓ 0.0

Index Scan using t_d_ref_directory_simple_pk_idx on d_ref_directory_simple dr (cost=0.28..9.01 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (key = dc.num_section)
  • Filter: ((key = master_key) AND (is_draft = 0) AND (sys_status = 0))
15. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4.73..35.97 rows=1 width=604) (actual rows= loops=)

  • Group Key: lt.doc
16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.73..35.24 rows=1 width=604) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.45..25.53 rows=1 width=532) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on d_rel_document_doc_class lt (cost=4.31..15.95 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (doc = d.key)
  • Filter: ((is_draft = 0) AND (sys_status = 0) AND (key = master_key))
19. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on t_d_rel_document_doc_class_doc_fk_idx (cost=0.00..4.31 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (doc = d.key)
20. 0.000 0.000 ↓ 0.0

Index Scan using t_d_ref_doc_class_pk_idx on d_ref_doc_class dc2 (cost=0.14..8.87 rows=1 width=540) (actual rows= loops=)

  • Index Cond: (key = lt.ref_doc_class)
  • Filter: ((key = master_key) AND (is_draft = 0) AND (sys_status = 0))
21. 0.000 0.000 ↓ 0.0

Index Scan using t_d_ref_directory_simple_pk_idx on d_ref_directory_simple dr1 (cost=0.28..9.01 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (key = dc2.num_section)
  • Filter: ((is_draft = 0) AND (sys_status = 0) AND (key = master_key))