#	exclusive	inclusive	rows x	rows	loops	node
1.	79.877	1,153.078	↑ 1.0	75	1	→ Limit (cost=4,398,737.29..4,398,737.85 rows=75 width=49) (actual time=1,073.183..1,153.078 rows=75 loops=1) Buffers: shared hit=502255, temp read=3565 written=3565
2.	0.016	1,073.201	↑ 16.7	75	1	→ Unique (cost=4,398,737.29..4,398,746.69 rows=1,253 width=49) (actual time=1,073.181..1,073.201 rows=75 loops=1) Buffers: shared hit=502255, temp read=3565 written=3565
3.	0.000	1,073.185	↑ 15.3	82	1	→ Sort (cost=4,398,737.29..4,398,740.42 rows=1,253 width=49) (actual time=1,073.180..1,073.185 rows=82 loops=1) Sort Key: businesspa3_.name, businesspa3_.c_bpartner_id Sort Method: quicksort Memory: 48kB Buffers: shared hit=502255, temp read=3565 written=3565
4.	86.618	1,152.814	↑ 5.7	221	1	→ Gather (cost=68,453.81..4,398,672.82 rows=1,253 width=49) (actual time=320.125..1,152.814 rows=221 loops=1) Workers Planned: 2 Workers Launched: 2 Buffers: shared hit=502255, temp read=3565 written=3565
5.	0.621	1,066.196	↑ 7.1	74	3	→ Nested Loop Anti Join (cost=67,453.81..4,397,547.52 rows=522 width=49) (actual time=305.573..1,066.196 rows=74 loops=3) Buffers: shared hit=502255, temp read=3565 written=3565
6.	1.177	1,065.568	↑ 6.4	81	3	→ Nested Loop (cost=67,453.39..4,394,011.09 rows=522 width=82) (actual time=305.549..1,065.568 rows=81 loops=3) Buffers: shared hit=501505, temp read=3565 written=3565
7.	4.309	1,064.378	↑ 6.4	81	3	→ Nested Loop (cost=67,452.83..4,390,319.71 rows=522 width=66) (actual time=305.516..1,064.378 rows=81 loops=3) Buffers: shared hit=500292, temp read=3565 written=3565
8.	27.470	1,060.056	↑ 121.3	316	3	→ Hash Join (cost=67,452.27..4,105,707.42 rows=38,335 width=66) (actual time=295.594..1,060.056 rows=316 loops=3) Hash Cond: ((orderline0_.m_product_id)::text = (product2_.m_product_id)::text) Buffers: shared hit=495546, temp read=3565 written=3565
9.	739.215	859.088	↑ 19.6	27,314	3	→ Parallel Bitmap Heap Scan on c_orderline orderline0_ (cost=47,258.61..4,064,955.82 rows=535,356 width=99) (actual time=92.834..859.088 rows=27,314 loops=3) Recheck Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text) Rows Removed by Index Recheck: 1159457 Filter: (qtydelivered <> qtyordered) Rows Removed by Filter: 438492 Heap Blocks: exact=19328 lossy=135851 Buffers: shared hit=414253
10.	119.873	119.873	↓ 1.1	1,397,419	1	→ Bitmap Index Scan on em_oborpre_ordline_org (cost=0.00..46,937.39 rows=1,291,310 width=0) (actual time=119.873..119.873 rows=1,397,419 loops=1) Index Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text) Buffers: shared hit=9985
11.	46.424	173.498	↓ 1.0	188,948	3	→ Hash (cost=16,458.06..16,458.06 rows=183,888 width=33) (actual time=173.497..173.498 rows=188,948 loops=3) Buckets: 131072 Batches: 4 Memory Usage: 4034kB Buffers: shared hit=81161, temp written=2745
12.	74.518	127.074	↓ 1.0	188,948	3	→ Nested Loop (cost=110.09..16,458.06 rows=183,888 width=33) (actual time=17.542..127.074 rows=188,948 loops=3) Buffers: shared hit=81161
13.	0.074	0.242	↑ 1.0	2	3	→ HashAggregate (cost=24.29..24.31 rows=2 width=33) (actual time=0.239..0.242 rows=2 loops=3) Group Key: (obre_resou4_.m_product_category_id)::text Buffers: shared hit=60
14.	0.168	0.168	↑ 1.0	343	3	→ Seq Scan on obre_resource obre_resou4_ (cost=0.00..23.43 rows=343 width=33) (actual time=0.016..0.168 rows=343 loops=3) Buffers: shared hit=60
15.	45.389	52.314	↓ 42.5	94,474	6	→ Bitmap Heap Scan on m_product product2_ (cost=85.80..8,194.63 rows=2,225 width=66) (actual time=8.740..52.314 rows=94,474 loops=6) Recheck Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text) Heap Blocks: exact=25675 Buffers: shared hit=81101
16.	6.925	6.925	↓ 42.5	94,474	6	→ Bitmap Index Scan on m_product_productcategory (cost=0.00..85.24 rows=2,225 width=0) (actual time=6.925..6.925 rows=94,474 loops=6) Index Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text) Buffers: shared hit=4076
17.	0.013	0.013	↓ 0.0	0	947	→ Index Scan using c_order_key on c_order order1_ (cost=0.56..7.42 rows=1 width=66) (actual time=0.013..0.013 rows=0 loops=947) Index Cond: ((c_order_id)::text = (orderline0_.c_order_id)::text) Filter: (((docstatus)::text = 'CO'::text) AND ((c_doctype_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,B475D71C30534BF2912C039F1770785E}'::text[]))) Rows Removed by Filter: 1 Buffers: shared hit=4746
18.	0.013	0.013	↑ 1.0	1	242	→ Index Scan using c_bpartner_key on c_bpartner businesspa3_ (cost=0.56..7.07 rows=1 width=49) (actual time=0.013..0.013 rows=1 loops=242) Index Cond: ((c_bpartner_id)::text = (order1_.c_bpartner_id)::text) Buffers: shared hit=1213
19.	0.007	0.007	↓ 0.0	0	242	→ Index Only Scan using obre_reservation_cordline_idx on obre_reservation obre_reser5_ (cost=0.42..6.76 rows=1 width=33) (actual time=0.007..0.007 rows=0 loops=242) Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text) Heap Fetches: 21 Buffers: shared hit=750

Planning time	:	2.178 ms
Execution time	:	1,153.216 ms

 Limit  (cost=4398737.29..4398737.85 rows=75 width=49) (actual time=1073.183..1153.078 rows=75 loops=1)
   Buffers: shared hit=502255, temp read=3565 written=3565
   ->  Unique  (cost=4398737.29..4398746.69 rows=1253 width=49) (actual time=1073.181..1073.201 rows=75 loops=1)
         Buffers: shared hit=502255, temp read=3565 written=3565
         ->  Sort  (cost=4398737.29..4398740.42 rows=1253 width=49) (actual time=1073.180..1073.185 rows=82 loops=1)
               Sort Key: businesspa3_.name, businesspa3_.c_bpartner_id
               Sort Method: quicksort  Memory: 48kB
               Buffers: shared hit=502255, temp read=3565 written=3565
               ->  Gather  (cost=68453.81..4398672.82 rows=1253 width=49) (actual time=320.125..1152.814 rows=221 loops=1)
                     Workers Planned: 2
                     Workers Launched: 2
                     Buffers: shared hit=502255, temp read=3565 written=3565
                     ->  Nested Loop Anti Join  (cost=67453.81..4397547.52 rows=522 width=49) (actual time=305.573..1066.196 rows=74 loops=3)
                           Buffers: shared hit=502255, temp read=3565 written=3565
                           ->  Nested Loop  (cost=67453.39..4394011.09 rows=522 width=82) (actual time=305.549..1065.568 rows=81 loops=3)
                                 Buffers: shared hit=501505, temp read=3565 written=3565
                                 ->  Nested Loop  (cost=67452.83..4390319.71 rows=522 width=66) (actual time=305.516..1064.378 rows=81 loops=3)
                                       Buffers: shared hit=500292, temp read=3565 written=3565
                                       ->  Hash Join  (cost=67452.27..4105707.42 rows=38335 width=66) (actual time=295.594..1060.056 rows=316 loops=3)
                                             Hash Cond: ((orderline0_.m_product_id)::text = (product2_.m_product_id)::text)
                                             Buffers: shared hit=495546, temp read=3565 written=3565
                                             ->  Parallel Bitmap Heap Scan on c_orderline orderline0_  (cost=47258.61..4064955.82 rows=535356 width=99) (actual time=92.834..859.088 rows=27314 loops=3)
                                                   Recheck Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text)
                                                   Rows Removed by Index Recheck: 1159457
                                                   Filter: (qtydelivered <> qtyordered)
                                                   Rows Removed by Filter: 438492
                                                   Heap Blocks: exact=19328 lossy=135851
                                                   Buffers: shared hit=414253
                                                   ->  Bitmap Index Scan on em_oborpre_ordline_org  (cost=0.00..46937.39 rows=1291310 width=0) (actual time=119.873..119.873 rows=1397419 loops=1)
                                                         Index Cond: ((ad_org_id)::text = '392FC5F103F442A597F2F4C07698A9A9'::text)
                                                         Buffers: shared hit=9985
                                             ->  Hash  (cost=16458.06..16458.06 rows=183888 width=33) (actual time=173.497..173.498 rows=188948 loops=3)
                                                   Buckets: 131072  Batches: 4  Memory Usage: 4034kB
                                                   Buffers: shared hit=81161, temp written=2745
                                                   ->  Nested Loop  (cost=110.09..16458.06 rows=183888 width=33) (actual time=17.542..127.074 rows=188948 loops=3)
                                                         Buffers: shared hit=81161
                                                         ->  HashAggregate  (cost=24.29..24.31 rows=2 width=33) (actual time=0.239..0.242 rows=2 loops=3)
                                                               Group Key: (obre_resou4_.m_product_category_id)::text
                                                               Buffers: shared hit=60
                                                               ->  Seq Scan on obre_resource obre_resou4_  (cost=0.00..23.43 rows=343 width=33) (actual time=0.016..0.168 rows=343 loops=3)
                                                                     Buffers: shared hit=60
                                                         ->  Bitmap Heap Scan on m_product product2_  (cost=85.80..8194.63 rows=2225 width=66) (actual time=8.740..52.314 rows=94474 loops=6)
                                                               Recheck Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
                                                               Heap Blocks: exact=25675
                                                               Buffers: shared hit=81101
                                                               ->  Bitmap Index Scan on m_product_productcategory  (cost=0.00..85.24 rows=2225 width=0) (actual time=6.925..6.925 rows=94474 loops=6)
                                                                     Index Cond: ((m_product_category_id)::text = (obre_resou4_.m_product_category_id)::text)
                                                                     Buffers: shared hit=4076
                                       ->  Index Scan using c_order_key on c_order order1_  (cost=0.56..7.42 rows=1 width=66) (actual time=0.013..0.013 rows=0 loops=947)
                                             Index Cond: ((c_order_id)::text = (orderline0_.c_order_id)::text)
                                             Filter: (((docstatus)::text = 'CO'::text) AND ((c_doctype_id)::text = ANY ('{4F94921D217F48A993FE766B8334B936,7CE7854395964A60A29EB3C5B7D46B40,116D158017A74901960473E3231FF91F,D457B6F9629240058922D59065FCC63A,D14BC7AD73FB4DD0B815E52DE3B31DFE,7C03FC3EE0FF40EEB1C07283E60E57F8,6BC35B437FF546299164FEEE30B3E950,B475D71C30534BF2912C039F1770785E}'::text[])))
                                             Rows Removed by Filter: 1
                                             Buffers: shared hit=4746
                                 ->  Index Scan using c_bpartner_key on c_bpartner businesspa3_  (cost=0.56..7.07 rows=1 width=49) (actual time=0.013..0.013 rows=1 loops=242)
                                       Index Cond: ((c_bpartner_id)::text = (order1_.c_bpartner_id)::text)
                                       Buffers: shared hit=1213
                           ->  Index Only Scan using obre_reservation_cordline_idx on obre_reservation obre_reser5_  (cost=0.42..6.76 rows=1 width=33) (actual time=0.007..0.007 rows=0 loops=242)
                                 Index Cond: (c_orderline_id = (orderline0_.c_orderline_id)::text)
                                 Heap Fetches: 21
                                 Buffers: shared hit=750
 Planning Time: 2.178 ms
 Execution Time: 1153.216 ms
(62 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	45.389 ms	3.9 %
Bitmap Index Scan	2	126.798 ms	11.0 %
Gather	1	86.618 ms	7.5 %
Hash	1	46.424 ms	4.0 %
Hash Join	1	27.470 ms	2.4 %
HashAggregate	1	0.074 ms	0.0 %
Index Only Scan	1	0.007 ms	0.0 %
Index Scan	2	0.026 ms	0.0 %
Limit	1	79.877 ms	6.9 %
Nested Loop	3	80.004 ms	6.9 %
Nested Loop Anti Join	1	0.621 ms	0.1 %
Parallel Bitmap Heap Scan	1	739.215 ms	64.1 %
Seq Scan	1	0.168 ms	0.0 %
Sort	1	0.000 ms	0.0 %
Unique	1	0.016 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
c_bpartner	1	0.013 ms	0.0 %
Index Scan	1	0.013 ms	100.0 %
c_order	1	0.013 ms	0.0 %
Index Scan	1	0.013 ms	100.0 %
c_orderline	1	739.215 ms	64.1 %
Parallel Bitmap Heap Scan	1	739.215 ms	100.0 %
m_product	1	45.389 ms	3.9 %
Bitmap Heap Scan	1	45.389 ms	100.0 %
obre_reservation	1	0.007 ms	0.0 %
Index Only Scan	1	0.007 ms	100.0 %
obre_resource	1	0.168 ms	0.0 %
Seq Scan	1	0.168 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xIyQ

Color mode:

Visible columns:

Per node type stats

Per table stats