maping logic jan code

mail@pastecode.io avatar
unknown
mysql
2 years ago
7.3 kB
2
Indexable
Never
"Sort  (cost=39703.65..39706.15 rows=1000 width=942) (actual time=2065.058..2068.546 rows=5970 loops=1)"
"  Sort Key: check_table.jan_code"
"  Sort Method: external merge  Disk: 3112kB"
"  Buffers: shared hit=118132 read=6305, temp read=389 written=390"
"  CTE check_table"
"    ->  CTE Scan on calculation_table  (cost=32317.82..32337.82 rows=1000 width=644) (actual time=109.513..1925.351 rows=5983 loops=1)"
"          Buffers: shared hit=94311 read=6189"
"          CTE calculation_table"
"            ->  CTE Scan on temp_table  (cost=32217.82..32317.82 rows=1000 width=644) (actual time=109.508..1912.567 rows=5983 loops=1)"
"                  Buffers: shared hit=94311 read=6189"
"                  CTE temp_table"
"                    ->  Nested Loop Left Join  (cost=3.38..32217.82 rows=1000 width=612) (actual time=109.485..1882.031 rows=5983 loops=1)"
"                          Buffers: shared hit=94311 read=6189"
"                          ->  Nested Loop Left Join  (cost=2.96..31599.87 rows=1000 width=612) (actual time=109.467..1872.692 rows=5983 loops=1)"
"                                Buffers: shared hit=94311 read=6189"
"                                ->  Nested Loop Left Join  (cost=2.54..24165.87 rows=1000 width=604) (actual time=109.449..1829.488 rows=5983 loops=1)"
"                                      Buffers: shared hit=76362 read=6189"
"                                      ->  Nested Loop Left Join  (cost=2.12..23547.91 rows=1000 width=604) (actual time=109.430..1820.695 rows=5983 loops=1)"
"                                            Buffers: shared hit=76362 read=6189"
"                                            ->  Nested Loop Left Join  (cost=1.69..16113.91 rows=1000 width=596) (actual time=109.411..1776.620 rows=5983 loops=1)"
"                                                  Buffers: shared hit=58418 read=6183"
"                                                  ->  Nested Loop Left Join  (cost=1.27..15495.96 rows=1000 width=596) (actual time=109.405..1766.946 rows=5983 loops=1)"
"                                                        Buffers: shared hit=58418 read=6183"
"                                                        ->  Nested Loop Left Join  (cost=0.85..8061.96 rows=1000 width=588) (actual time=109.376..1713.147 rows=5983 loops=1)"
"                                                              Buffers: shared hit=40471 read=6181"
"                                                              ->  Nested Loop Left Join  (cost=0.43..7444.00 rows=1000 width=588) (actual time=109.359..871.347 rows=5983 loops=1)"
"                                                                    Buffers: shared hit=20751 read=2978"
"                                                                    ->  Function Scan on dblink rows  (cost=0.01..10.01 rows=1000 width=580) (actual time=108.649..110.740 rows=5983 loops=1)"
"                                                                          Buffers: shared read=1"
"                                                                    ->  Index Scan using master_maruetsu_product_jan_jan_jan_type_key on master_maruetsu_product_jan jan_from_33  (cost=0.42..7.42 rows=1 width=22) (actual time=0.124..0.125 rows=1 loops=5983)"
"                                                                          Index Cond: ((jan)::text = (rows.no_33)::text)"
"                                                                          Buffers: shared hit=20751 read=2977"
"                                                              ->  Index Only Scan using maruetsu_data_product_product_code_key on maruetsu_data_product pp_from_33  (cost=0.42..0.62 rows=1 width=8) (actual time=0.138..0.138 rows=1 loops=5983)"
"                                                                    Index Cond: (product_code = (jan_from_33.product_code)::text)"
"                                                                    Heap Fetches: 5727"
"                                                                    Buffers: shared hit=19720 read=3203"
"                                                        ->  Index Scan using master_maruetsu_product_jan_jan_jan_type_key on master_maruetsu_product_jan jan_from_upc1  (cost=0.42..7.42 rows=1 width=22) (actual time=0.007..0.007 rows=0 loops=5983)"
"                                                              Index Cond: ((jan)::text = (rows.code_upc1)::text)"
"                                                              Buffers: shared hit=17947 read=2"
"                                                  ->  Index Only Scan using maruetsu_data_product_product_code_key on maruetsu_data_product pp_from_upc1  (cost=0.42..0.62 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=5983)"
"                                                        Index Cond: (product_code = (jan_from_upc1.product_code)::text)"
"                                                        Heap Fetches: 0"
"                                            ->  Index Scan using master_maruetsu_product_jan_jan_jan_type_key on master_maruetsu_product_jan jan_from_upc2  (cost=0.42..7.42 rows=1 width=22) (actual time=0.006..0.006 rows=0 loops=5983)"
"                                                  Index Cond: ((jan)::text = (rows.code_upc2)::text)"
"                                                  Buffers: shared hit=17944 read=6"
"                                      ->  Index Only Scan using maruetsu_data_product_product_code_key on maruetsu_data_product pp_from_upc2  (cost=0.42..0.62 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=5983)"
"                                            Index Cond: (product_code = (jan_from_upc2.product_code)::text)"
"                                            Heap Fetches: 0"
"                                ->  Index Scan using master_maruetsu_product_jan_jan_jan_type_key on master_maruetsu_product_jan jan_from_upc3  (cost=0.42..7.42 rows=1 width=22) (actual time=0.006..0.006 rows=0 loops=5983)"
"                                      Index Cond: ((jan)::text = (rows.code_upc3)::text)"
"                                      Buffers: shared hit=17949"
"                          ->  Index Only Scan using maruetsu_data_product_product_code_key on maruetsu_data_product pp_from_upc3  (cost=0.42..0.62 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=5983)"
"                                Index Cond: (product_code = (jan_from_upc3.product_code)::text)"
"                                Heap Fetches: 0"
"  ->  Nested Loop  (cost=0.42..7316.00 rows=1000 width=942) (actual time=113.790..2028.061 rows=5970 loops=1)"
"        Buffers: shared hit=118129 read=6305"
"        ->  CTE Scan on check_table  (cost=0.00..20.00 rows=1000 width=644) (actual time=109.515..1930.664 rows=5983 loops=1)"
"              Buffers: shared hit=94311 read=6189"
"        ->  Index Scan using maruetsu_data_product_product_code_key on maruetsu_data_product pp  (cost=0.42..7.30 rows=1 width=298) (actual time=0.013..0.013 rows=1 loops=5983)"
"              Index Cond: ((product_code)::text = (check_table.product_code_from_else_if_condition)::text)"
"              Filter: (product_id IS NOT NULL)"
"              Buffers: shared hit=23818 read=116"
"Planning Time: 7.837 ms"
"Execution Time: 2074.368 ms"