explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dxdC

Settings
# exclusive inclusive rows x rows loops node
1. 1.490 1,823.977 ↑ 4.1 4,834 1

Nested Loop (cost=1.40..70,703.56 rows=19,588 width=7) (actual time=15.593..1,823.977 rows=4,834 loops=1)

2. 1.990 898.803 ↑ 5.6 8,714 1

Nested Loop (cost=0.97..42,647.04 rows=48,816 width=11) (actual time=5.156..898.803 rows=8,714 loops=1)

3. 9.668 9.668 ↑ 1.6 147 1

Index Scan using enterprise_lft on enterprise u0 (cost=0.41..281.90 rows=239 width=4) (actual time=0.015..9.668 rows=147 loops=1)

  • Index Cond: ((lft >= 5612) AND (lft <= 5905))
  • Filter: (tree_id = 8)
4. 887.145 887.145 ↑ 3.5 59 147

Index Scan using document_base_ent_id_date_formatting_f1cc9952_idx on document_base (cost=0.56..175.22 rows=204 width=19) (actual time=1.777..6.035 rows=59 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: 0
5. 923.684 923.684 ↑ 1.0 1 8,714

Index Scan using document_pay_doc_out_pkey on document_pay_doc_out (cost=0.43..0.56 rows=1 width=4) (actual time=0.105..0.106 rows=1 loops=8,714)

  • Index Cond: (basedocumentmodel_ptr_id = document_base.id)
  • Filter: (NOT is_template)
Planning time : 2.030 ms
Execution time : 1,824.501 ms