explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NSMm

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

Gather (cost=15,356.94..446,420.04 rows=46,245 width=7) (actual rows= loops=)

  • Workers Planned: 6
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=14,356.94..440,795.54 rows=7,708 width=7) (actual rows= loops=)

  • Hash Cond: (document_base.ent_id = u0.id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,346.53..438,620.39 rows=42,865 width=15) (actual rows= loops=)

  • Hash Cond: (document_base.id = document_other_calcs.basedocumentmodel_ptr_id)
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on document_base (cost=0.00..421,063.47 rows=1,275,131 width=19) (actual rows= loops=)

  • Filter: ((document_storno_id IS NULL) AND (date_formatting >= '2018-01-01'::date) AND (date_formatting <= '2018-12-31'::date) AND (number ~ '[0-9]+'::text))
5. 0.000 0.000 ↓ 0.0

Hash (cost=6,882.90..6,882.90 rows=437,090 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on document_other_calcs (cost=0.00..6,882.90 rows=437,090 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,996.48..1,996.48 rows=1,115 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on enterprise u0 (cost=25.85..1,996.48 rows=1,115 width=4) (actual rows= loops=)

  • Recheck Cond: ((lft >= 1934) AND (lft <= 2081))
  • Filter: (tree_id = 8)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on enterprise_lft (cost=0.00..25.57 rows=1,115 width=0) (actual rows= loops=)

  • Index Cond: ((lft >= 1934) AND (lft <= 2081))