output.txt
text/plain
Filename: output.txt
Type: text/plain
Part: 0
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on sp_op_uct (cost=28.85..1612.12 rows=22644 width=382) (actual time=1.283..39.484 rows=2 loops=1)
Filter: ((hashed subplan) OR (sp_op_id = 34123))
SubPlan
-> Index Scan using sp_op_product_bal_zak on sp_op_produkt (cost=0.00..28.83 rows=7 width=4) (actual time=0.018..0.022 rows=1 loops=1)
Index Cond: (bal_zak = 34123)
Total runtime: 39.798 ms
(6 rows)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop (cost=29.02..106.84 rows=17 width=382) (actual time=0.120..0.157 rows=2 loops=1)
-> HashAggregate (cost=29.02..29.02 rows=8 width=4) (actual time=0.093..0.099 rows=2 loops=1)
-> Subquery Scan "IN_subquery" (cost=0.00..29.00 rows=8 width=4) (actual time=0.028..0.073 rows=2 loops=1)
-> Append (cost=0.00..28.92 rows=8 width=4) (actual time=0.023..0.058 rows=2 loops=1)
-> Subquery Scan "*SELECT* 1" (cost=0.00..28.90 rows=7 width=4) (actual time=0.019..0.028 rows=1 loops=1)
-> Index Scan using sp_op_product_bal_zak on sp_op_produkt (cost=0.00..28.83 rows=7 width=4) (actual time=0.013..0.017 rows=1 loops=1)
Index Cond: (bal_zak = 34123)
-> Subquery Scan "*SELECT* 2" (cost=0.00..0.02 rows=1 width=0) (actual time=0.008..0.015 rows=1 loops=1)
-> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.003..0.006 rows=1 loops=1)
-> Index Scan using sp_op_uct_sp_op_id on sp_op_uct (cost=0.00..9.70 rows=2 width=382) (actual time=0.011..0.015 rows=1 loops=2)
Index Cond: (sp_op_uct.sp_op_id = "outer".sp_op_id)
Total runtime: 0.310 ms
(12 rows)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Append (cost=28.85..106.77 rows=13 width=382) (actual time=0.058..0.108 rows=2 loops=1)
-> Subquery Scan "*SELECT* 1" (cost=28.85..97.05 rows=11 width=382) (actual time=0.054..0.071 rows=1 loops=1)
-> Nested Loop (cost=28.85..96.94 rows=11 width=382) (actual time=0.048..0.061 rows=1 loops=1)
-> HashAggregate (cost=28.85..28.85 rows=7 width=4) (actual time=0.031..0.033 rows=1 loops=1)
-> Index Scan using sp_op_product_bal_zak on sp_op_produkt (cost=0.00..28.83 rows=7 width=4) (actual time=0.010..0.013 rows=1 loops=1)
Index Cond: (bal_zak = 34123)
-> Index Scan using sp_op_uct_sp_op_id on sp_op_uct (cost=0.00..9.70 rows=2 width=382) (actual time=0.008..0.011 rows=1 loops=1)
Index Cond: (sp_op_uct.sp_op_id = "outer".sp_op_id)
-> Subquery Scan "*SELECT* 2" (cost=0.00..9.72 rows=2 width=382) (actual time=0.012..0.019 rows=1 loops=1)
-> Index Scan using sp_op_uct_sp_op_id on sp_op_uct (cost=0.00..9.70 rows=2 width=382) (actual time=0.007..0.010 rows=1 loops=1)
Index Cond: (sp_op_id = 34123)
Total runtime: 0.387 ms
(12 rows)
SET
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on sp_op_uct (cost=26.50..1609.78 rows=22644 width=382) (actual time=1.206..37.903 rows=2 loops=1)
Filter: ((hashed subplan) OR (sp_op_id = 34123))
SubPlan
-> Bitmap Heap Scan on sp_op_produkt (cost=2.02..26.49 rows=7 width=4) (actual time=0.037..0.040 rows=1 loops=1)
Recheck Cond: (bal_zak = 34123)
-> Bitmap Index Scan on sp_op_product_bal_zak (cost=0.00..2.02 rows=7 width=0) (actual time=0.026..0.026 rows=1 loops=1)
Index Cond: (bal_zak = 34123)
Total runtime: 37.993 ms
(8 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop (cost=26.68..104.49 rows=17 width=382) (actual time=0.148..0.186 rows=2 loops=1)
-> HashAggregate (cost=26.68..26.68 rows=8 width=4) (actual time=0.124..0.129 rows=2 loops=1)
-> Subquery Scan "IN_subquery" (cost=2.02..26.66 rows=8 width=4) (actual time=0.063..0.108 rows=2 loops=1)
-> Append (cost=2.02..26.58 rows=8 width=4) (actual time=0.058..0.093 rows=2 loops=1)
-> Subquery Scan "*SELECT* 1" (cost=2.02..26.56 rows=7 width=4) (actual time=0.053..0.060 rows=1 loops=1)
-> Bitmap Heap Scan on sp_op_produkt (cost=2.02..26.49 rows=7 width=4) (actual time=0.048..0.050 rows=1 loops=1)
Recheck Cond: (bal_zak = 34123)
-> Bitmap Index Scan on sp_op_product_bal_zak (cost=0.00..2.02 rows=7 width=0) (actual time=0.036..0.036 rows=1 loops=1)
Index Cond: (bal_zak = 34123)
-> Subquery Scan "*SELECT* 2" (cost=0.00..0.02 rows=1 width=0) (actual time=0.008..0.015 rows=1 loops=1)
-> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.003..0.005 rows=1 loops=1)
-> Index Scan using sp_op_uct_sp_op_id on sp_op_uct (cost=0.00..9.70 rows=2 width=382) (actual time=0.010..0.014 rows=1 loops=2)
Index Cond: (sp_op_uct.sp_op_id = "outer".sp_op_id)
Total runtime: 0.330 ms
(14 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Append (cost=26.50..104.42 rows=13 width=382) (actual time=0.086..0.135 rows=2 loops=1)
-> Subquery Scan "*SELECT* 1" (cost=26.50..94.70 rows=11 width=382) (actual time=0.081..0.099 rows=1 loops=1)
-> Nested Loop (cost=26.50..94.59 rows=11 width=382) (actual time=0.075..0.089 rows=1 loops=1)
-> HashAggregate (cost=26.50..26.50 rows=7 width=4) (actual time=0.055..0.058 rows=1 loops=1)
-> Bitmap Heap Scan on sp_op_produkt (cost=2.02..26.49 rows=7 width=4) (actual time=0.036..0.039 rows=1 loops=1)
Recheck Cond: (bal_zak = 34123)
-> Bitmap Index Scan on sp_op_product_bal_zak (cost=0.00..2.02 rows=7 width=0) (actual time=0.024..0.024 rows=1 loops=1)
Index Cond: (bal_zak = 34123)
-> Index Scan using sp_op_uct_sp_op_id on sp_op_uct (cost=0.00..9.70 rows=2 width=382) (actual time=0.010..0.013 rows=1 loops=1)
Index Cond: (sp_op_uct.sp_op_id = "outer".sp_op_id)
-> Subquery Scan "*SELECT* 2" (cost=0.00..9.72 rows=2 width=382) (actual time=0.012..0.020 rows=1 loops=1)
-> Index Scan using sp_op_uct_sp_op_id on sp_op_uct (cost=0.00..9.70 rows=2 width=382) (actual time=0.007..0.010 rows=1 loops=1)
Index Cond: (sp_op_id = 34123)
Total runtime: 0.416 ms
(14 rows)