explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ecak

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 11.901 143.647 ↑ 4.7 18,381 1

Nested Loop (cost=40.09..407,028.19 rows=86,953 width=7) (actual time=0.126..143.647 rows=18,381 loops=1)

2. 2.359 51.976 ↑ 7.7 26,590 1

Nested Loop (cost=39.66..268,433.85 rows=204,845 width=11) (actual time=0.072..51.976 rows=26,590 loops=1)

3. 0.332 0.372 ↑ 7.1 147 1

Bitmap Heap Scan on enterprise u0 (cost=39.10..1,890.31 rows=1,042 width=4) (actual time=0.057..0.372 rows=147 loops=1)

  • Recheck Cond: ((lft >= 6170) AND (lft <= 6463))
  • Filter: (tree_id = 8)
  • Heap Blocks: exact=141
4. 0.040 0.040 ↑ 7.1 147 1

Bitmap Index Scan on enterprise_lft (cost=0.00..38.84 rows=1,042 width=0) (actual time=0.040..0.040 rows=147 loops=1)

  • Index Cond: ((lft >= 6170) AND (lft <= 6463))
5. 49.245 49.245 ↑ 1.1 181 147

Index Scan using document_base_ent_id_date_formatting_f1cc9952_idx on document_base (cost=0.56..253.83 rows=197 width=19) (actual time=0.011..0.335 rows=181 loops=147)

  • Index Cond: ((ent_id = u0.id) AND (date_formatting >= '2019-01-01'::date) AND (date_formatting <= '2019-12-31'::date))
  • Filter: ((document_storno_id IS NULL) AND (number ~ '[0-9]+'::text))
  • Rows Removed by Filter: 1
6. 79.770 79.770 ↑ 1.0 1 26,590

Index Scan using document_pay_doc_out_pkey on document_pay_doc_out (cost=0.43..0.67 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=26,590)

  • Index Cond: (basedocumentmodel_ptr_id = document_base.id)
  • Filter: (NOT is_template)