Result: s3R

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.000	0.000	↓ 0.0			→ Update (cost=21686.97..31819.93 rows=2 width=42) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash Join (cost=21686.97..31819.93 rows=2 width=42) (actual time=.. rows= loops=) Hash Cond: (((temp.merchant_product_id)::text = (product.merchant_product_id)::text) AND (product_attribute_value.product_id = product.id) AND (product_attribute_value.extraction_id = product.latest_extraction))
0.000	0.000	↓ 0.0			→ Hash Join (cost=21206.53..30463.39 rows=29203 width=48) (actual time=.. rows= loops=) Hash Cond: ((product_attribute_value.attribute_id = attribute.id) AND (product_attribute_value.value_id = value.id))
0.000	0.000	↓ 0.0			→ Seq Scan on product_attribute_value (cost=0.00..2646.39 rows=171739 width=22) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash (cost=17414.38..17414.38 rows=166210 width=34) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash Join (cost=4605.22..17414.38 rows=166210 width=34) (actual time=.. rows= loops=) Hash Cond: ((temp.value_md5)::text = (value.value_md5)::text)
0.000	0.000	↓ 0.0			→ Hash Join (cost=1.32..5715.80 rows=166210 width=57) (actual time=.. rows= loops=) Hash Cond: ((temp.attribute)::text = (attribute.attribute)::text)
0.000	0.000	↓ 0.0			→ Seq Scan on temp_product_attribute_value temp (cost=0.00..3429.10 rows=166210 width=60) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash (cost=1.14..1.14 rows=14 width=23) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Seq Scan on attribute (cost=0.00..1.14 rows=14 width=23) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash (cost=3117.18..3117.18 rows=69818 width=43) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Seq Scan on value (cost=0.00..3117.18 rows=69818 width=43) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash (cost=266.34..266.34 rows=12234 width=22) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Seq Scan on product (cost=0.00..266.34 rows=12234 width=22) (actual time=.. rows= loops=)

 Update  (cost=21686.97..31819.93 rows=2 width=42)
   ->  Hash Join  (cost=21686.97..31819.93 rows=2 width=42)
         Hash Cond: (((temp.merchant_product_id)::text = (product.merchant_product_id)::text) AND (product_attribute_value.product_id = product.id) AND (product_attribute_value.extraction_id = product.latest_extraction))
         ->  Hash Join  (cost=21206.53..30463.39 rows=29203 width=48)
               Hash Cond: ((product_attribute_value.attribute_id = attribute.id) AND (product_attribute_value.value_id = value.id))
               ->  Seq Scan on product_attribute_value  (cost=0.00..2646.39 rows=171739 width=22)
               ->  Hash  (cost=17414.38..17414.38 rows=166210 width=34)
                     ->  Hash Join  (cost=4605.22..17414.38 rows=166210 width=34)
                           Hash Cond: ((temp.value_md5)::text = (value.value_md5)::text)
                           ->  Hash Join  (cost=1.32..5715.80 rows=166210 width=57)
                                 Hash Cond: ((temp.attribute)::text = (attribute.attribute)::text)
                                 ->  Seq Scan on temp_product_attribute_value temp  (cost=0.00..3429.10 rows=166210 width=60)
                                 ->  Hash  (cost=1.14..1.14 rows=14 width=23)
                                       ->  Seq Scan on attribute  (cost=0.00..1.14 rows=14 width=23)
                           ->  Hash  (cost=3117.18..3117.18 rows=69818 width=43)
                                 ->  Seq Scan on value  (cost=0.00..3117.18 rows=69818 width=43)
         ->  Hash  (cost=266.34..266.34 rows=12234 width=22)
               ->  Seq Scan on product  (cost=0.00..266.34 rows=12234 width=22)
(18 rows)

Per node type stats

node type	count	sum of times	% of query
Hash	4	0.000 ms	0.0 %
Hash Join	4	0.000 ms	0.0 %
Seq Scan	5	0.000 ms	0.0 %
Update	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
attribute	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
product	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
product_attribute_value	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
temp_product_attribute_value	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
value	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: s3R

Colorize:

Columns visibility:

Per node type stats

Per table stats