#	exclusive	inclusive	rows x	rows	loops	node
1.	173.254	2,258.031	↓ 6.9	15,275	1	→ Nested Loop Left Join (cost=8.82..381,207.76 rows=2,216 width=777) (actual time=0.617..2,258.031 rows=15,275 loops=1) Output: d.id, d.parent_id, d.del_rec, CASE dbot.typeof WHEN 'Integro.Objects.Modules.Docflow.DocflowObjects.IncomingDocument'::text THEN 2 WHEN 'Integro.Objects.Modules.Docflow.DocflowObjects.OutgoingDocument'::text THEN 3 WHEN 'Integro.Objects.Modules.D (...) Buffers: shared hit=661147
2.	37.649	878.052	↓ 6.9	15,275	1	→ Nested Loop Left Join (cost=8.26..46,461.11 rows=2,216 width=748) (actual time=0.293..878.052 rows=15,275 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, dbot.typeof, read.business_object_id, fav.business_object_id, pc.property_value, pis.property_value, psn.p (...) Buffers: shared hit=315918
3.	35.596	764.028	↓ 6.9	15,275	1	→ Nested Loop Left Join (cost=7.70..31,979.53 rows=2,216 width=735) (actual time=0.283..764.028 rows=15,275 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.id, dbot.typeof, read.business_object_id, fav.business_object_id, pc.property_value, pis.property_ (...) Buffers: shared hit=254724
4.	38.743	621.507	↓ 6.9	15,275	1	→ Nested Loop Left Join (cost=7.14..17,497.94 rows=2,216 width=706) (actual time=0.271..621.507 rows=15,275 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.id, dbot.typeof, read.business_object_id, fav.business_object_id, pc.property_value Buffers: shared hit=186211
5.	27.662	414.739	↓ 6.9	15,275	1	→ Hash Join (cost=6.59..3,016.36 rows=2,216 width=677) (actual time=0.245..414.739 rows=15,275 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.id, dbot.typeof, read.business_object_id, fav.business_object_id Hash Cond: (c.bo_type = cbot.id) Buffers: shared hit=113298
6.	59.176	387.010	↓ 6.9	15,275	1	→ Nested Loop (cost=4.80..2,984.10 rows=2,216 width=679) (actual time=0.167..387.010 rows=15,275 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.bo_type, c.id, dbot.typeof, read.business_object_id, fav.business_object_id Buffers: shared hit=113297
7.	30.146	234.184	↓ 8.7	18,730	1	→ Hash Left Join (cost=4.51..2,095.39 rows=2,146 width=598) (actual time=0.155..234.184 rows=18,730 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, dbot.typeof, read.business_object_id, fav.business_object_id Hash Cond: (d.id = fav.business_object_id) Buffers: shared hit=56967
8.	45.324	203.950	↓ 8.7	18,730	1	→ Nested Loop Left Join (cost=1.94..2,082.05 rows=2,146 width=582) (actual time=0.059..203.950 rows=18,730 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, dbot.typeof, read.business_object_id Buffers: shared hit=56966
9.	37.083	64.976	↓ 8.7	18,730	1	→ Hash Join (cost=1.52..796.27 rows=2,146 width=566) (actual time=0.039..64.976 rows=18,730 loops=1) Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, dbot.typeof Hash Cond: (d.bo_type = dbot.id) Buffers: shared hit=427
10.	27.870	27.870	↑ 1.0	24,729	1	→ Seq Scan on public.t_document d (cost=0.00..679.42 rows=25,031 width=52) (actual time=0.007..27.870 rows=24,729 loops=1) 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 Filter: ((NOT d.is_duplicate) OR d.del_rec) Rows Removed by Filter: 305 Buffers: shared hit=426
11.	0.006	0.023	↑ 1.0	3	1	→ Hash (cost=1.48..1.48 rows=3 width=518) (actual time=0.023..0.023 rows=3 loops=1) Output: dbot.typeof, dbot.id Buckets: 1024 Batches: 1 Memory Usage: 1kB Buffers: shared hit=1
12.	0.017	0.017	↑ 1.0	3	1	→ Seq Scan on public.t_business_object_types dbot (cost=0.00..1.48 rows=3 width=518) (actual time=0.006..0.017 rows=3 loops=1) Output: dbot.typeof, dbot.id Filter: ((dbot.typeof)::text = ANY ('{Integro.Objects.Modules.Docflow.DocflowObjects.IncomingDocument,Integro.Objects.Modules.Docflow.DocflowObjects.OutgoingDocument,Integro.Objects.Modules.Docf (...) Rows Removed by Filter: 32 Buffers: shared hit=1
13.	93.650	93.650	↓ 0.0	0	18,730	→ Index Only Scan using l_readers_pkey on public.l_readers read (cost=0.42..0.59 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=18,730) Output: read.business_object_id, read.employee_id Index Cond: ((read.business_object_id = d.id) AND (read.employee_id = 'a5098b77-8081-42d4-b912-10a83e086747'::uuid)) Heap Fetches: 234 Buffers: shared hit=56539
14.	0.041	0.088	↓ 1.0	45	1	→ Hash (cost=2.03..2.03 rows=44 width=16) (actual time=0.088..0.088 rows=45 loops=1) Output: fav.business_object_id Buckets: 1024 Batches: 1 Memory Usage: 3kB Buffers: shared hit=1
15.	0.047	0.047	↓ 1.0	45	1	→ Seq Scan on public.l_favorites fav (cost=0.00..2.03 rows=44 width=16) (actual time=0.008..0.047 rows=45 loops=1) Output: fav.business_object_id Filter: (fav.employee_id = 'a5098b77-8081-42d4-b912-10a83e086747'::uuid) Rows Removed by Filter: 43 Buffers: shared hit=1
16.	93.650	93.650	↑ 1.0	1	18,730	→ Index Scan using t_card_parent_id_idx on public.t_card c (cost=0.29..0.40 rows=1 width=97) (actual time=0.005..0.005 rows=1 loops=18,730) 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)) Rows Removed by Filter: 0 Buffers: shared hit=56330
17.	0.032	0.067	↑ 1.0	35	1	→ Hash (cost=1.35..1.35 rows=35 width=2) (actual time=0.067..0.067 rows=35 loops=1) Output: cbot.id Buckets: 1024 Batches: 1 Memory Usage: 2kB Buffers: shared hit=1
18.	0.035	0.035	↑ 1.0	35	1	→ Seq Scan on public.t_business_object_types cbot (cost=0.00..1.35 rows=35 width=2) (actual time=0.009..0.035 rows=35 loops=1) Output: cbot.id Buffers: shared hit=1
19.	168.025	168.025	↑ 1.0	1	15,275	→ Index Scan using t_properties_business_object_id_property_idx on public.t_properties pc (cost=0.56..6.53 rows=1 width=45) (actual time=0.010..0.011 rows=1 loops=15,275) Output: pc.business_object_id, pc.property, pc.property_value Index Cond: ((pc.business_object_id = c.id) AND ((pc.property)::text = 'Correspondent'::text)) Buffers: shared hit=72913
20.	106.925	106.925	↓ 0.0	0	15,275	→ Index Scan using t_properties_business_object_id_property_idx on public.t_properties pis (cost=0.56..6.53 rows=1 width=45) (actual time=0.006..0.007 rows=0 loops=15,275) Output: pis.business_object_id, pis.property, pis.property_value Index Cond: ((pis.business_object_id = c.id) AND ((pis.property)::text = 'IsSection'::text)) Buffers: shared hit=68513
21.	76.375	76.375	↓ 0.0	0	15,275	→ Index Scan using t_properties_business_object_id_property_idx on public.t_properties psn (cost=0.56..6.53 rows=1 width=45) (actual time=0.005..0.005 rows=0 loops=15,275) Output: psn.business_object_id, psn.property, psn.property_value Index Cond: ((psn.business_object_id = c.id) AND ((psn.property)::text = 'SectionNumber'::text)) Buffers: shared hit=61194
22.	137.475	137.475	↑ 1.0	1	15,275	→ Index Scan using t_properties_business_object_id_property_idx on public.t_properties pt (cost=0.56..6.59 rows=1 width=45) (actual time=0.008..0.009 rows=1 loops=15,275) Output: pt.business_object_id, pt.property, pt.property_value Index Cond: ((pt.business_object_id = d.id) AND ((pt.property)::text = 'Theme'::text)) Buffers: shared hit=76533
23.						SubPlan (forNested Loop Left Join)
24.	122.200	122.200	↑ 7.0	1	15,275	→ Index Scan using t_docflow_businessobjects_parent_id_idx on public.t_docflow_businessobjects (cost=0.42..52.75 rows=7 width=0) (actual time=0.008..0.008 rows=1 loops=15,275) Index Cond: (t_docflow_businessobjects.parent_id = d.id) Filter: ((NOT t_docflow_businessobjects.del_rec) AND (t_docflow_businessobjects.business_object_type <> ALL ('{2,101,102,103,400,1000,1100,5002}'::integer[]))) Rows Removed by Filter: 1 Buffers: shared hit=69034
25.	0.000	0.000	↓ 0.0		0	→ Seq Scan on public.t_docflow_businessobjects t_docflow_businessobjects_1 (cost=0.00..79,018.98 rows=369,780 width=16) (never executed) Output: t_docflow_businessobjects_1.parent_id Filter: ((NOT t_docflow_businessobjects_1.del_rec) AND (t_docflow_businessobjects_1.business_object_type <> ALL ('{2,101,102,103,400,1000,1100,5002}'::integer[])))
26.	45.825	549.900	↓ 0.0	0	15,275	→ Limit (cost=68.28..68.28 rows=1 width=9) (actual time=0.036..0.036 rows=0 loops=15,275) Output: control_date_sub_query.controldate, control_date_sub_query.executed Buffers: shared hit=99831
27.	61.100	504.075	↓ 0.0	0	15,275	→ Sort (cost=68.28..68.28 rows=2 width=9) (actual time=0.033..0.033 rows=0 loops=15,275) Output: control_date_sub_query.controldate, control_date_sub_query.executed Sort Key: control_date_sub_query.executed Sort Method: quicksort Memory: 25kB Buffers: shared hit=99831
28.	45.825	442.975	↓ 0.0	0	15,275	→ Subquery Scan on control_date_sub_query (cost=68.22..68.27 rows=2 width=9) (actual time=0.028..0.029 rows=0 loops=15,275) Output: control_date_sub_query.controldate, control_date_sub_query.executed Buffers: shared hit=99831
29.	30.550	397.150	↓ 0.0	0	15,275	→ HashAggregate (cost=68.22..68.25 rows=2 width=28) (actual time=0.026..0.026 rows=0 loops=15,275) Output: ((rt.work_status = ANY ('{3,6,14}'::integer[]))), min(COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit)) Group Key: (rt.work_status = ANY ('{3,6,14}'::integer[])) Buffers: shared hit=99831
30.	141.715	366.600	↓ 0.0	0	15,275	→ Nested Loop (cost=4.59..68.21 rows=2 width=28) (actual time=0.021..0.024 rows=0 loops=15,275) Output: (rt.work_status = ANY ('{3,6,14}'::integer[])), rt.prolongation_date, rt.outer_limit, rt.inner_limit Buffers: shared hit=99831
31.	61.100	137.475	↑ 2.0	1	15,275	→ Bitmap Heap Scan on public.t_resolution r (cost=4.30..11.94 rows=2 width=32) (actual time=0.008..0.009 rows=1 loops=15,275) 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.sender_id (...) Recheck Cond: (r.parent_id = d.id) Filter: ((NOT r.del_rec) AND r.controlling) Rows Removed by Filter: 0 Heap Blocks: exact=16566 Buffers: shared hit=47246
32.	76.375	76.375	↑ 2.0	1	15,275	→ Bitmap Index Scan on t_resolution_parent_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.005..0.005 rows=1 loops=15,275) Index Cond: (r.parent_id = d.id) Buffers: shared hit=30680
33.	87.394	87.410	↓ 0.0	0	17,482	→ Index Scan using t_resolution_task_parent_id_idx on public.t_resolution_task rt (cost=0.29..28.12 rows=1 width=60) (actual time=0.005..0.005 rows=0 loops=17,482) 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_s (...) Index Cond: (rt.parent_id = r.id) Filter: ((NOT rt.del_rec) AND (COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit) IS NOT NULL) AND (rt.work_status <> ALL ('{7,13}'::integer[])) AND ((r.signer_enterprise_id = '3176cd78-0acf-467e-aa51-6cd (...) Rows Removed by Filter: 1 Buffers: shared hit=52585
34.						SubPlan (forIndex Scan)
35.	0.008	0.016	↓ 0.0	0	1	→ Bitmap Heap Scan on public.t_resolution_task_executer rte (cost=4.45..19.81 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1) Recheck Cond: (rte.parent_id = rt.id) Filter: ((NOT rte.del_rec) AND (rte.work_status <> ALL ('{7,13}'::integer[])) AND (rte.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid)) Rows Removed by Filter: 2 Heap Blocks: exact=1 Buffers: shared hit=4
36.	0.008	0.008	↑ 2.0	2	1	→ Bitmap Index Scan on t_resolution_task_executer_parent_id_idx (cost=0.00..4.45 rows=4 width=0) (actual time=0.008..0.008 rows=2 loops=1) Index Cond: (rte.parent_id = rt.id) Buffers: shared hit=3
37.	0.000	0.000	↓ 0.0		0	→ Seq Scan on public.t_resolution_task_executer rte_1 (cost=0.00..2,159.32 rows=15,513 width=16) (never executed) Output: rte_1.parent_id Filter: ((NOT rte_1.del_rec) AND (rte_1.work_status <> ALL ('{7,13}'::integer[])) AND (rte_1.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid))
38.	106.925	397.150	↑ 1.0	1	15,275	→ Aggregate (cost=68.23..68.24 rows=1 width=28) (actual time=0.025..0.026 rows=1 loops=15,275) Output: array_agg(DISTINCT CASE WHEN (rt_1.work_status = ANY ('{3,6,14}'::integer[])) THEN 3 ELSE CASE WHEN (COALESCE(rt_1.prolongation_date, rt_1.outer_limit, rt_1.inner_limit) < now()) THEN 5 ELSE 1 END END) Buffers: shared hit=99831
39.	113.372	290.225	↓ 0.0	0	15,275	→ Nested Loop (cost=4.59..68.20 rows=2 width=28) (actual time=0.017..0.019 rows=0 loops=15,275) Output: rt_1.work_status, rt_1.prolongation_date, rt_1.outer_limit, rt_1.inner_limit Buffers: shared hit=99831
40.	45.825	106.925	↑ 2.0	1	15,275	→ Bitmap Heap Scan on public.t_resolution r_1 (cost=4.30..11.94 rows=2 width=32) (actual time=0.006..0.007 rows=1 loops=15,275) Output: r_1.id, r_1.parent_id, r_1.bo_type, r_1.rec_date, r_1.del_rec, r_1.parent_executer_id, r_1.parent_resolution_id, r_1.controlling, r_1.created_by, r_1.signer_workplace_id, r_1.signer_enterprise_id, r_1.signer_employee_id, r_1.s (...) Recheck Cond: (r_1.parent_id = d.id) Filter: ((NOT r_1.del_rec) AND r_1.controlling) Rows Removed by Filter: 0 Heap Blocks: exact=16566 Buffers: shared hit=47246
41.	61.100	61.100	↑ 2.0	1	15,275	→ Bitmap Index Scan on t_resolution_parent_id_idx (cost=0.00..4.30 rows=2 width=0) (actual time=0.004..0.004 rows=1 loops=15,275) Index Cond: (r_1.parent_id = d.id) Buffers: shared hit=30680
42.	69.917	69.928	↓ 0.0	0	17,482	→ Index Scan using t_resolution_task_parent_id_idx on public.t_resolution_task rt_1 (cost=0.29..28.12 rows=1 width=60) (actual time=0.003..0.004 rows=0 loops=17,482) Output: rt_1.id, rt_1.parent_id, rt_1.bo_type, rt_1.rec_date, rt_1.del_rec, rt_1.outer_limit, rt_1.inner_limit, rt_1.outer_ex_limit, rt_1.prolongation_date, rt_1.svod_limit, rt_1.control_type, rt_1.periodicity, rt_1.period_end_date, r (...) Index Cond: (rt_1.parent_id = r_1.id) Filter: ((NOT rt_1.del_rec) AND (COALESCE(rt_1.prolongation_date, rt_1.outer_limit, rt_1.inner_limit) IS NOT NULL) AND (rt_1.work_status <> ALL ('{7,13}'::integer[])) AND ((r_1.signer_enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d (...) Rows Removed by Filter: 1 Buffers: shared hit=52585
43.						SubPlan (forIndex Scan)
44.	0.006	0.011	↓ 0.0	0	1	→ Bitmap Heap Scan on public.t_resolution_task_executer rte_2 (cost=4.45..19.81 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=1) Recheck Cond: (rte_2.parent_id = rt_1.id) Filter: ((NOT rte_2.del_rec) AND (rte_2.work_status <> ALL ('{7,13}'::integer[])) AND (rte_2.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid)) Rows Removed by Filter: 2 Heap Blocks: exact=1 Buffers: shared hit=4
45.	0.005	0.005	↑ 2.0	2	1	→ Bitmap Index Scan on t_resolution_task_executer_parent_id_idx (cost=0.00..4.45 rows=4 width=0) (actual time=0.005..0.005 rows=2 loops=1) Index Cond: (rte_2.parent_id = rt_1.id) Buffers: shared hit=3
46.	0.000	0.000	↓ 0.0		0	→ Seq Scan on public.t_resolution_task_executer rte_3 (cost=0.00..2,159.32 rows=15,513 width=16) (never executed) Output: rte_3.parent_id Filter: ((NOT rte_3.del_rec) AND (rte_3.work_status <> ALL ('{7,13}'::integer[])) AND (rte_3.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid))

'Nested Loop Left Join  (cost=8.82..381207.76 rows=2216 width=777) (actual time=0.617..2258.031 rows=15275 loops=1)'
'  Output: d.id, d.parent_id, d.del_rec, CASE dbot.typeof WHEN 'Integro.Objects.Modules.Docflow.DocflowObjects.IncomingDocument'::text THEN 2 WHEN 'Integro.Objects.Modules.Docflow.DocflowObjects.OutgoingDocument'::text THEN 3 WHEN 'Integro.Objects.Modules.D (...)'
'  Buffers: shared hit=661147'
'  ->  Nested Loop Left Join  (cost=8.26..46461.11 rows=2216 width=748) (actual time=0.293..878.052 rows=15275 loops=1)'
'        Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, dbot.typeof, read.business_object_id, fav.business_object_id, pc.property_value, pis.property_value, psn.p (...)'
'        Buffers: shared hit=315918'
'        ->  Nested Loop Left Join  (cost=7.70..31979.53 rows=2216 width=735) (actual time=0.283..764.028 rows=15275 loops=1)'
'              Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.id, dbot.typeof, read.business_object_id, fav.business_object_id, pc.property_value, pis.property_ (...)'
'              Buffers: shared hit=254724'
'              ->  Nested Loop Left Join  (cost=7.14..17497.94 rows=2216 width=706) (actual time=0.271..621.507 rows=15275 loops=1)'
'                    Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.id, dbot.typeof, read.business_object_id, fav.business_object_id, pc.property_value'
'                    Buffers: shared hit=186211'
'                    ->  Hash Join  (cost=6.59..3016.36 rows=2216 width=677) (actual time=0.245..414.739 rows=15275 loops=1)'
'                          Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.id, dbot.typeof, read.business_object_id, fav.business_object_id'
'                          Hash Cond: (c.bo_type = cbot.id)'
'                          Buffers: shared hit=113298'
'                          ->  Nested Loop  (cost=4.80..2984.10 rows=2216 width=679) (actual time=0.167..387.010 rows=15275 loops=1)'
'                                Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, c.reg_number, c.reg_date, c.recipients_employee, c.recipients_enterprise, c.bo_type, c.id, dbot.typeof, read.business_object_id, fav.business_object_id'
'                                Buffers: shared hit=113297'
'                                ->  Hash Left Join  (cost=4.51..2095.39 rows=2146 width=598) (actual time=0.155..234.184 rows=18730 loops=1)'
'                                      Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, dbot.typeof, read.business_object_id, fav.business_object_id'
'                                      Hash Cond: (d.id = fav.business_object_id)'
'                                      Buffers: shared hit=56967'
'                                      ->  Nested Loop Left Join  (cost=1.94..2082.05 rows=2146 width=582) (actual time=0.059..203.950 rows=18730 loops=1)'
'                                            Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, dbot.typeof, read.business_object_id'
'                                            Buffers: shared hit=56966'
'                                            ->  Hash Join  (cost=1.52..796.27 rows=2146 width=566) (actual time=0.039..64.976 rows=18730 loops=1)'
'                                                  Output: d.id, d.parent_id, d.del_rec, d.is_duplicate, d.created_by, dbot.typeof'
'                                                  Hash Cond: (d.bo_type = dbot.id)'
'                                                  Buffers: shared hit=427'
'                                                  ->  Seq Scan on public.t_document d  (cost=0.00..679.42 rows=25031 width=52) (actual time=0.007..27.870 rows=24729 loops=1)'
'                                                        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'
'                                                        Filter: ((NOT d.is_duplicate) OR d.del_rec)'
'                                                        Rows Removed by Filter: 305'
'                                                        Buffers: shared hit=426'
'                                                  ->  Hash  (cost=1.48..1.48 rows=3 width=518) (actual time=0.023..0.023 rows=3 loops=1)'
'                                                        Output: dbot.typeof, dbot.id'
'                                                        Buckets: 1024  Batches: 1  Memory Usage: 1kB'
'                                                        Buffers: shared hit=1'
'                                                        ->  Seq Scan on public.t_business_object_types dbot  (cost=0.00..1.48 rows=3 width=518) (actual time=0.006..0.017 rows=3 loops=1)'
'                                                              Output: dbot.typeof, dbot.id'
'                                                              Filter: ((dbot.typeof)::text = ANY ('{Integro.Objects.Modules.Docflow.DocflowObjects.IncomingDocument,Integro.Objects.Modules.Docflow.DocflowObjects.OutgoingDocument,Integro.Objects.Modules.Docf (...)'
'                                                              Rows Removed by Filter: 32'
'                                                              Buffers: shared hit=1'
'                                            ->  Index Only Scan using l_readers_pkey on public.l_readers read  (cost=0.42..0.59 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=18730)'
'                                                  Output: read.business_object_id, read.employee_id'
'                                                  Index Cond: ((read.business_object_id = d.id) AND (read.employee_id = 'a5098b77-8081-42d4-b912-10a83e086747'::uuid))'
'                                                  Heap Fetches: 234'
'                                                  Buffers: shared hit=56539'
'                                      ->  Hash  (cost=2.03..2.03 rows=44 width=16) (actual time=0.088..0.088 rows=45 loops=1)'
'                                            Output: fav.business_object_id'
'                                            Buckets: 1024  Batches: 1  Memory Usage: 3kB'
'                                            Buffers: shared hit=1'
'                                            ->  Seq Scan on public.l_favorites fav  (cost=0.00..2.03 rows=44 width=16) (actual time=0.008..0.047 rows=45 loops=1)'
'                                                  Output: fav.business_object_id'
'                                                  Filter: (fav.employee_id = 'a5098b77-8081-42d4-b912-10a83e086747'::uuid)'
'                                                  Rows Removed by Filter: 43'
'                                                  Buffers: shared hit=1'
'                                ->  Index Scan using t_card_parent_id_idx on public.t_card c  (cost=0.29..0.40 rows=1 width=97) (actual time=0.005..0.005 rows=1 loops=18730)'
'                                      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))'
'                                      Rows Removed by Filter: 0'
'                                      Buffers: shared hit=56330'
'                          ->  Hash  (cost=1.35..1.35 rows=35 width=2) (actual time=0.067..0.067 rows=35 loops=1)'
'                                Output: cbot.id'
'                                Buckets: 1024  Batches: 1  Memory Usage: 2kB'
'                                Buffers: shared hit=1'
'                                ->  Seq Scan on public.t_business_object_types cbot  (cost=0.00..1.35 rows=35 width=2) (actual time=0.009..0.035 rows=35 loops=1)'
'                                      Output: cbot.id'
'                                      Buffers: shared hit=1'
'                    ->  Index Scan using t_properties_business_object_id_property_idx on public.t_properties pc  (cost=0.56..6.53 rows=1 width=45) (actual time=0.010..0.011 rows=1 loops=15275)'
'                          Output: pc.business_object_id, pc.property, pc.property_value'
'                          Index Cond: ((pc.business_object_id = c.id) AND ((pc.property)::text = 'Correspondent'::text))'
'                          Buffers: shared hit=72913'
'              ->  Index Scan using t_properties_business_object_id_property_idx on public.t_properties pis  (cost=0.56..6.53 rows=1 width=45) (actual time=0.006..0.007 rows=0 loops=15275)'
'                    Output: pis.business_object_id, pis.property, pis.property_value'
'                    Index Cond: ((pis.business_object_id = c.id) AND ((pis.property)::text = 'IsSection'::text))'
'                    Buffers: shared hit=68513'
'        ->  Index Scan using t_properties_business_object_id_property_idx on public.t_properties psn  (cost=0.56..6.53 rows=1 width=45) (actual time=0.005..0.005 rows=0 loops=15275)'
'              Output: psn.business_object_id, psn.property, psn.property_value'
'              Index Cond: ((psn.business_object_id = c.id) AND ((psn.property)::text = 'SectionNumber'::text))'
'              Buffers: shared hit=61194'
'  ->  Index Scan using t_properties_business_object_id_property_idx on public.t_properties pt  (cost=0.56..6.59 rows=1 width=45) (actual time=0.008..0.009 rows=1 loops=15275)'
'        Output: pt.business_object_id, pt.property, pt.property_value'
'        Index Cond: ((pt.business_object_id = d.id) AND ((pt.property)::text = 'Theme'::text))'
'        Buffers: shared hit=76533'
'  SubPlan 1'
'    ->  Index Scan using t_docflow_businessobjects_parent_id_idx on public.t_docflow_businessobjects  (cost=0.42..52.75 rows=7 width=0) (actual time=0.008..0.008 rows=1 loops=15275)'
'          Index Cond: (t_docflow_businessobjects.parent_id = d.id)'
'          Filter: ((NOT t_docflow_businessobjects.del_rec) AND (t_docflow_businessobjects.business_object_type <> ALL ('{2,101,102,103,400,1000,1100,5002}'::integer[])))'
'          Rows Removed by Filter: 1'
'          Buffers: shared hit=69034'
'  SubPlan 2'
'    ->  Seq Scan on public.t_docflow_businessobjects t_docflow_businessobjects_1  (cost=0.00..79018.98 rows=369780 width=16) (never executed)'
'          Output: t_docflow_businessobjects_1.parent_id'
'          Filter: ((NOT t_docflow_businessobjects_1.del_rec) AND (t_docflow_businessobjects_1.business_object_type <> ALL ('{2,101,102,103,400,1000,1100,5002}'::integer[])))'
'  SubPlan 5'
'    ->  Limit  (cost=68.28..68.28 rows=1 width=9) (actual time=0.036..0.036 rows=0 loops=15275)'
'          Output: control_date_sub_query.controldate, control_date_sub_query.executed'
'          Buffers: shared hit=99831'
'          ->  Sort  (cost=68.28..68.28 rows=2 width=9) (actual time=0.033..0.033 rows=0 loops=15275)'
'                Output: control_date_sub_query.controldate, control_date_sub_query.executed'
'                Sort Key: control_date_sub_query.executed'
'                Sort Method: quicksort  Memory: 25kB'
'                Buffers: shared hit=99831'
'                ->  Subquery Scan on control_date_sub_query  (cost=68.22..68.27 rows=2 width=9) (actual time=0.028..0.029 rows=0 loops=15275)'
'                      Output: control_date_sub_query.controldate, control_date_sub_query.executed'
'                      Buffers: shared hit=99831'
'                      ->  HashAggregate  (cost=68.22..68.25 rows=2 width=28) (actual time=0.026..0.026 rows=0 loops=15275)'
'                            Output: ((rt.work_status = ANY ('{3,6,14}'::integer[]))), min(COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit))'
'                            Group Key: (rt.work_status = ANY ('{3,6,14}'::integer[]))'
'                            Buffers: shared hit=99831'
'                            ->  Nested Loop  (cost=4.59..68.21 rows=2 width=28) (actual time=0.021..0.024 rows=0 loops=15275)'
'                                  Output: (rt.work_status = ANY ('{3,6,14}'::integer[])), rt.prolongation_date, rt.outer_limit, rt.inner_limit'
'                                  Buffers: shared hit=99831'
'                                  ->  Bitmap Heap Scan on public.t_resolution r  (cost=4.30..11.94 rows=2 width=32) (actual time=0.008..0.009 rows=1 loops=15275)'
'                                        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.sender_id (...)'
'                                        Recheck Cond: (r.parent_id = d.id)'
'                                        Filter: ((NOT r.del_rec) AND r.controlling)'
'                                        Rows Removed by Filter: 0'
'                                        Heap Blocks: exact=16566'
'                                        Buffers: shared hit=47246'
'                                        ->  Bitmap Index Scan on t_resolution_parent_id_idx  (cost=0.00..4.30 rows=2 width=0) (actual time=0.005..0.005 rows=1 loops=15275)'
'                                              Index Cond: (r.parent_id = d.id)'
'                                              Buffers: shared hit=30680'
'                                  ->  Index Scan using t_resolution_task_parent_id_idx on public.t_resolution_task rt  (cost=0.29..28.12 rows=1 width=60) (actual time=0.005..0.005 rows=0 loops=17482)'
'                                        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_s (...)'
'                                        Index Cond: (rt.parent_id = r.id)'
'                                        Filter: ((NOT rt.del_rec) AND (COALESCE(rt.prolongation_date, rt.outer_limit, rt.inner_limit) IS NOT NULL) AND (rt.work_status <> ALL ('{7,13}'::integer[])) AND ((r.signer_enterprise_id = '3176cd78-0acf-467e-aa51-6cd (...)'
'                                        Rows Removed by Filter: 1'
'                                        Buffers: shared hit=52585'
'                                        SubPlan 3'
'                                          ->  Bitmap Heap Scan on public.t_resolution_task_executer rte  (cost=4.45..19.81 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)'
'                                                Recheck Cond: (rte.parent_id = rt.id)'
'                                                Filter: ((NOT rte.del_rec) AND (rte.work_status <> ALL ('{7,13}'::integer[])) AND (rte.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid))'
'                                                Rows Removed by Filter: 2'
'                                                Heap Blocks: exact=1'
'                                                Buffers: shared hit=4'
'                                                ->  Bitmap Index Scan on t_resolution_task_executer_parent_id_idx  (cost=0.00..4.45 rows=4 width=0) (actual time=0.008..0.008 rows=2 loops=1)'
'                                                      Index Cond: (rte.parent_id = rt.id)'
'                                                      Buffers: shared hit=3'
'                                        SubPlan 4'
'                                          ->  Seq Scan on public.t_resolution_task_executer rte_1  (cost=0.00..2159.32 rows=15513 width=16) (never executed)'
'                                                Output: rte_1.parent_id'
'                                                Filter: ((NOT rte_1.del_rec) AND (rte_1.work_status <> ALL ('{7,13}'::integer[])) AND (rte_1.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid))'
'  SubPlan 8'
'    ->  Aggregate  (cost=68.23..68.24 rows=1 width=28) (actual time=0.025..0.026 rows=1 loops=15275)'
'          Output: array_agg(DISTINCT CASE WHEN (rt_1.work_status = ANY ('{3,6,14}'::integer[])) THEN 3 ELSE CASE WHEN (COALESCE(rt_1.prolongation_date, rt_1.outer_limit, rt_1.inner_limit) < now()) THEN 5 ELSE 1 END END)'
'          Buffers: shared hit=99831'
'          ->  Nested Loop  (cost=4.59..68.20 rows=2 width=28) (actual time=0.017..0.019 rows=0 loops=15275)'
'                Output: rt_1.work_status, rt_1.prolongation_date, rt_1.outer_limit, rt_1.inner_limit'
'                Buffers: shared hit=99831'
'                ->  Bitmap Heap Scan on public.t_resolution r_1  (cost=4.30..11.94 rows=2 width=32) (actual time=0.006..0.007 rows=1 loops=15275)'
'                      Output: r_1.id, r_1.parent_id, r_1.bo_type, r_1.rec_date, r_1.del_rec, r_1.parent_executer_id, r_1.parent_resolution_id, r_1.controlling, r_1.created_by, r_1.signer_workplace_id, r_1.signer_enterprise_id, r_1.signer_employee_id, r_1.s (...)'
'                      Recheck Cond: (r_1.parent_id = d.id)'
'                      Filter: ((NOT r_1.del_rec) AND r_1.controlling)'
'                      Rows Removed by Filter: 0'
'                      Heap Blocks: exact=16566'
'                      Buffers: shared hit=47246'
'                      ->  Bitmap Index Scan on t_resolution_parent_id_idx  (cost=0.00..4.30 rows=2 width=0) (actual time=0.004..0.004 rows=1 loops=15275)'
'                            Index Cond: (r_1.parent_id = d.id)'
'                            Buffers: shared hit=30680'
'                ->  Index Scan using t_resolution_task_parent_id_idx on public.t_resolution_task rt_1  (cost=0.29..28.12 rows=1 width=60) (actual time=0.003..0.004 rows=0 loops=17482)'
'                      Output: rt_1.id, rt_1.parent_id, rt_1.bo_type, rt_1.rec_date, rt_1.del_rec, rt_1.outer_limit, rt_1.inner_limit, rt_1.outer_ex_limit, rt_1.prolongation_date, rt_1.svod_limit, rt_1.control_type, rt_1.periodicity, rt_1.period_end_date, r (...)'
'                      Index Cond: (rt_1.parent_id = r_1.id)'
'                      Filter: ((NOT rt_1.del_rec) AND (COALESCE(rt_1.prolongation_date, rt_1.outer_limit, rt_1.inner_limit) IS NOT NULL) AND (rt_1.work_status <> ALL ('{7,13}'::integer[])) AND ((r_1.signer_enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d (...)'
'                      Rows Removed by Filter: 1'
'                      Buffers: shared hit=52585'
'                      SubPlan 6'
'                        ->  Bitmap Heap Scan on public.t_resolution_task_executer rte_2  (cost=4.45..19.81 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=1)'
'                              Recheck Cond: (rte_2.parent_id = rt_1.id)'
'                              Filter: ((NOT rte_2.del_rec) AND (rte_2.work_status <> ALL ('{7,13}'::integer[])) AND (rte_2.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid))'
'                              Rows Removed by Filter: 2'
'                              Heap Blocks: exact=1'
'                              Buffers: shared hit=4'
'                              ->  Bitmap Index Scan on t_resolution_task_executer_parent_id_idx  (cost=0.00..4.45 rows=4 width=0) (actual time=0.005..0.005 rows=2 loops=1)'
'                                    Index Cond: (rte_2.parent_id = rt_1.id)'
'                                    Buffers: shared hit=3'
'                      SubPlan 7'
'                        ->  Seq Scan on public.t_resolution_task_executer rte_3  (cost=0.00..2159.32 rows=15513 width=16) (never executed)'
'                              Output: rte_3.parent_id'
'                              Filter: ((NOT rte_3.del_rec) AND (rte_3.work_status <> ALL ('{7,13}'::integer[])) AND (rte_3.enterprise_id = '3176cd78-0acf-467e-aa51-6cdc7960d0a6'::uuid))'
'Planning time: 8.819 ms'
'Execution time: 2268.789 ms'

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	106.925 ms	4.7 %
Bitmap Heap Scan	4	106.939 ms	4.7 %
Bitmap Index Scan	4	137.488 ms	6.1 %
Hash	3	0.079 ms	0.0 %
Hash Join	2	64.745 ms	2.9 %
Hash Left Join	1	30.146 ms	1.3 %
HashAggregate	1	30.550 ms	1.4 %
Index Only Scan	1	93.650 ms	4.1 %
Index Scan	8	861.961 ms	38.2 %
Limit	1	45.825 ms	2.0 %
Nested Loop	3	314.263 ms	13.9 %
Nested Loop Left Join	5	330.566 ms	14.6 %
Seq Scan	7	27.969 ms	1.2 %
Sort	1	61.100 ms	2.7 %
Subquery Scan	1	45.825 ms	2.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.l_favorites	1	0.047 ms	0.0 %
Seq Scan	1	0.047 ms	100.0 %
public.l_readers	1	93.650 ms	4.1 %
Index Only Scan	1	93.650 ms	100.0 %
public.t_business_object_types	2	0.052 ms	0.0 %
Seq Scan	2	0.052 ms	100.0 %
public.t_card	1	93.650 ms	4.1 %
Index Scan	1	93.650 ms	100.0 %
public.t_docflow_businessobjects	2	122.200 ms	5.4 %
Index Scan	1	122.200 ms	100.0 %
Seq Scan	1	0.000 ms	0.0 %
public.t_document	1	27.870 ms	1.2 %
Seq Scan	1	27.870 ms	100.0 %
public.t_properties	4	488.800 ms	21.6 %
Index Scan	4	488.800 ms	100.0 %
public.t_resolution	2	106.925 ms	4.7 %
Bitmap Heap Scan	2	106.925 ms	100.0 %
public.t_resolution_task	2	157.311 ms	7.0 %
Index Scan	2	157.311 ms	100.0 %
public.t_resolution_task_executer	4	0.014 ms	0.0 %
Bitmap Heap Scan	2	0.014 ms	100.0 %
Seq Scan	2	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1fbR

Color mode:

Visible columns:

Per node type stats

Per table stats