explain.depesz.com

PostgreSQL's explain analyze made readable

Result: POvH

Settings
# exclusive inclusive rows x rows loops node
1. 3.730 722.683 ↓ 4.5 1,412 1

HashAggregate (cost=18,918.21..18,921.32 rows=311 width=85) (actual time=721.607..722.683 rows=1,412 loops=1)

  • Output: r.id, r.signer_workplace_id, r.controler_workplace_id, rt.work_status, rt.control_type, (COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit)), rte.work_status, rte.svod
  • Group Key: r.id, r.signer_workplace_id, r.controler_workplace_id, rt.work_status, rt.control_type, COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit), rte.work_status, rte.svod
  • Buffers: shared hit=292987
2. 4.987 718.953 ↓ 4.5 1,412 1

Nested Loop (cost=3.17..18,911.99 rows=311 width=85) (actual time=40.656..718.953 rows=1,412 loops=1)

  • Output: r.id, r.signer_workplace_id, r.controler_workplace_id, rt.work_status, rt.control_type, COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit), rte.work_status, rte.svod
  • Buffers: shared hit=292987
3. 38.951 706.906 ↓ 4.7 1,412 1

Nested Loop Left Join (cost=2.88..18,780.76 rows=298 width=117) (actual time=40.641..706.906 rows=1,412 loops=1)

  • Output: r.id, r.signer_workplace_id, r.controler_workplace_id, r.parent_id, rt.work_status, rt.control_type, rt.prolongation_date, rt.outer_limit, rt.inner_limit, d.id, rte.work_status, rte.svod
  • Filter: ((rte.id IS NOT NULL) OR (r.signer_workplace_id = 'dee28a69-5763-4371-93a0-bb9f501d8779'::uuid) OR (r.controler_workplace_id = 'dee28a69-5763-4371-93a0-bb9f501d8779'::uuid))
  • Rows Removed by Filter: 19154
  • Buffers: shared hit=288725
4. 50.632 544.559 ↓ 69.0 20,566 1

Nested Loop (cost=2.46..18,535.72 rows=298 width=128) (actual time=0.085..544.559 rows=20,566 loops=1)

  • Output: r.id, r.signer_workplace_id, r.controler_workplace_id, r.parent_id, rt.work_status, rt.control_type, rt.prolongation_date, rt.outer_limit, rt.inner_limit, rt.id, d.id
  • Buffers: shared hit=195435
5. 50.115 391.097 ↓ 69.5 20,566 1

Nested Loop (cost=2.17..18,414.73 rows=296 width=96) (actual time=0.074..391.097 rows=20,566 loops=1)

  • Output: r.id, r.signer_workplace_id, r.controler_workplace_id, r.parent_id, d.id, rbo.id
  • Buffers: shared hit=133496
6. 57.504 237.507 ↓ 69.0 20,695 1

Nested Loop (cost=1.89..18,284.87 rows=300 width=80) (actual time=0.063..237.507 rows=20,695 loops=1)

  • Output: r.id, r.signer_workplace_id, r.controler_workplace_id, r.parent_id, rbo.id
  • Buffers: shared hit=71238
7. 35.138 55.833 ↓ 2.4 20,695 1

Hash Join (cost=1.46..836.67 rows=8,696 width=64) (actual time=0.041..55.833 rows=20,695 loops=1)

  • Output: r.id, r.signer_workplace_id, r.controler_workplace_id, r.parent_id
  • Hash Cond: (r.bo_type = t_business_object_types.id)
  • Buffers: shared hit=524
8. 20.673 20.673 ↑ 1.0 21,411 1

Seq Scan on public.t_resolution r (cost=0.00..741.26 rows=21,741 width=66) (actual time=0.009..20.673 rows=21,411 loops=1)

  • Output: r.id, r.parent_id, r.bo_type, r.rec_date, r.del_rec, r.parent_executer_id, r.parent_resolution_id, r.controlling, r.created_by, r.signer_workplace_id, r.signer_enterprise_id, r.signer_employee_id, r.sende (...)
  • Filter: ((NOT r.del_rec) AND r.controlling)
  • Rows Removed by Filter: 84
  • Buffers: shared hit=523
9. 0.004 0.022 ↑ 1.0 2 1

Hash (cost=1.44..1.44 rows=2 width=2) (actual time=0.022..0.022 rows=2 loops=1)

  • Output: t_business_object_types.id
  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=1
10. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on public.t_business_object_types (cost=0.00..1.44 rows=2 width=2) (actual time=0.009..0.018 rows=2 loops=1)

  • Output: t_business_object_types.id
  • Filter: ((t_business_object_types.typeof)::text = ANY ('{Integro.Objects.Modules.Docflow.DocflowObjects.Resolution,Integro.Objects.Modules.Docflow.DocflowObjects.ActItem}'::text[]))
  • Rows Removed by Filter: 33
  • Buffers: shared hit=1
11. 124.170 124.170 ↑ 1.0 1 20,695

Index Only Scan using t_docflow_businessobjects_pkey on public.t_docflow_businessobjects rbo (cost=0.42..2.00 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=20,695)

  • Output: rbo.id, rbo.business_object_type
  • Index Cond: ((rbo.id = r.id) AND (rbo.business_object_type = 100))
  • Heap Fetches: 5258
  • Buffers: shared hit=70714
12. 103.475 103.475 ↑ 1.0 1 20,695

Index Scan using pkey_id on public.t_document d (cost=0.29..0.42 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=20,695)

  • Output: d.id, d.parent_id, d.bo_type, d.rec_date, d.del_rec, d.is_rejected, d.created_by, d.creation_time, d.enterprise_id, d.is_private, d.folder_id, d.sender_id, d.is_duplicate
  • Index Cond: (d.id = r.parent_id)
  • Filter: (NOT d.del_rec)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=62258
13. 102.830 102.830 ↑ 1.0 1 20,566

Index Scan using t_resolution_task_parent_id_idx on public.t_resolution_task rt (cost=0.29..0.40 rows=1 width=64) (actual time=0.004..0.005 rows=1 loops=20,566)

  • Output: rt.id, rt.parent_id, rt.bo_type, rt.rec_date, rt.del_rec, rt.outer_limit, rt.inner_limit, rt.outer_ex_limit, rt.prolongation_date, rt.svod_limit, rt.control_type, rt.periodicity, rt.period_end_date, rt.work_status, rt.exec (...)
  • Index Cond: (rt.parent_id = r.id)
  • Filter: (NOT rt.del_rec)
  • Buffers: shared hit=61939
14. 123.396 123.396 ↓ 0.0 0 20,566

Index Scan using t_resolution_task_executer_parent_id_idx on public.t_resolution_task_executer rte (cost=0.42..0.81 rows=1 width=37) (actual time=0.006..0.006 rows=0 loops=20,566)

  • Output: rte.id, rte.parent_id, rte.bo_type, rte.rec_date, rte.del_rec, rte.index_in_task, rte.is_inner, rte.executer_id, rte.enterprise_id, rte.work_status, rte.complete_date, rte.svod
  • Index Cond: (rt.id = rte.parent_id)
  • Filter: ((NOT rte.del_rec) AND (rte.executer_id = 'dee28a69-5763-4371-93a0-bb9f501d8779'::uuid))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=93290
15. 7.060 7.060 ↑ 1.0 1 1,412

Index Scan using t_card_parent_id_idx on public.t_card c (cost=0.29..0.43 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1,412)

  • Output: c.id, c.parent_id, c.bo_type, c.rec_date, c.del_rec, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise
  • Index Cond: (c.parent_id = d.id)
  • Filter: ((NOT c.del_rec) AND ((c.reg_number)::text <> ''::text))
  • Buffers: shared hit=4262
Planning time : 5.933 ms
Execution time : 723.800 ms