Result: 88c

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.000	0.000	↓ 0.0			→ Nested Loop Left Join (cost=24881.83..379402.31 rows=10535 width=359) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash Left Join (cost=24881.83..234620.96 rows=10535 width=355) (actual time=.. rows= loops=) Hash Cond: (products.product_group_id = product_groups.id)
0.000	0.000	↓ 0.0			→ Nested Loop (cost=23632.43..233260.25 rows=10535 width=351) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Nested Loop (cost=23632.43..160614.51 rows=10535 width=330) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash Left Join (cost=23632.43..62957.16 rows=10867 width=117) (actual time=.. rows= loops=) Hash Cond: (products.rubric_id = rubrics.id)
0.000	0.000	↓ 0.0			→ Hash Left Join (cost=4072.54..43181.02 rows=10867 width=120) (actual time=.. rows= loops=) Hash Cond: (products.rubric_id = rubrics_denormalization_tree.rubric_id)
0.000	0.000	↓ 0.0			→ Bitmap Heap Scan on products (cost=232.29..39124.51 rows=10867 width=88) (actual time=.. rows= loops=) Recheck Cond: ((id >= 7740001) AND (id <= 7750000)) Filter: (CASE WHEN (state = 'pending'::product_state) THEN 1 WHEN (state = 'accepted'::product_state) THEN 2 WHEN (state = 'changed'::product_state) THEN 3 WHEN (state = 'declined'::product_state) THEN 4 WHEN (state = 'deleted'::product_state) THEN 5 ELSE NULL::integer END <> 5)
0.000	0.000	↓ 0.0			→ Bitmap Index Scan on ipart_products_id_5mln_6mln (cost=0.00..229.58 rows=10922 width=0) (actual time=.. rows= loops=) Index Cond: ((id >= 7740001) AND (id <= 7750000))
0.000	0.000	↓ 0.0			→ Hash (cost=2550.11..2550.11 rows=103211 width=32) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Seq Scan on rubrics_denormalization_tree (cost=0.00..2550.11 rows=103211 width=32) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Hash (cost=18261.06..18261.06 rows=103906 width=5) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Seq Scan on rubrics (cost=0.00..18261.06 rows=103906 width=5) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Index Scan using index_search_index_products_on_product_id on search_index_products (cost=0.00..8.97 rows=1 width=217) (actual time=.. rows= loops=) Index Cond: (search_index_products.product_id = products.id)
0.000	0.000	↓ 0.0			→ Index Scan using companies_pkey on companies (cost=0.00..6.88 rows=1 width=25) (actual time=.. rows= loops=) Index Cond: (companies.id = products.company_id)
0.000	0.000	↓ 0.0			→ Hash (cost=919.18..919.18 rows=26418 width=8) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Seq Scan on product_groups (cost=0.00..919.18 rows=26418 width=8) (actual time=.. rows= loops=)
0.000	0.000	↓ 0.0			→ Index Scan using i_product_images_product_id on product_images (cost=0.00..13.41 rows=5 width=8) (actual time=.. rows= loops=) Index Cond: (product_images.product_id = products.id) Filter: (product_images."position" = 1)

"Nested Loop Left Join  (cost=24881.83..379402.31 rows=10535 width=359)"
"  ->  Hash Left Join  (cost=24881.83..234620.96 rows=10535 width=355)"
"        Hash Cond: (products.product_group_id = product_groups.id)"
"        ->  Nested Loop  (cost=23632.43..233260.25 rows=10535 width=351)"
"              ->  Nested Loop  (cost=23632.43..160614.51 rows=10535 width=330)"
"                    ->  Hash Left Join  (cost=23632.43..62957.16 rows=10867 width=117)"
"                          Hash Cond: (products.rubric_id = rubrics.id)"
"                          ->  Hash Left Join  (cost=4072.54..43181.02 rows=10867 width=120)"
"                                Hash Cond: (products.rubric_id = rubrics_denormalization_tree.rubric_id)"
"                                ->  Bitmap Heap Scan on products  (cost=232.29..39124.51 rows=10867 width=88)"
"                                      Recheck Cond: ((id >= 7740001) AND (id <= 7750000))"
"                                      Filter: (CASE WHEN (state = 'pending'::product_state) THEN 1 WHEN (state = 'accepted'::product_state) THEN 2 WHEN (state = 'changed'::product_state) THEN 3 WHEN (state = 'declined'::product_state) THEN 4 WHEN (state = 'deleted'::product_state) THEN 5 ELSE NULL::integer END <> 5)"
"                                      ->  Bitmap Index Scan on ipart_products_id_5mln_6mln  (cost=0.00..229.58 rows=10922 width=0)"
"                                            Index Cond: ((id >= 7740001) AND (id <= 7750000))"
"                                ->  Hash  (cost=2550.11..2550.11 rows=103211 width=32)"
"                                      ->  Seq Scan on rubrics_denormalization_tree  (cost=0.00..2550.11 rows=103211 width=32)"
"                          ->  Hash  (cost=18261.06..18261.06 rows=103906 width=5)"
"                                ->  Seq Scan on rubrics  (cost=0.00..18261.06 rows=103906 width=5)"
"                    ->  Index Scan using index_search_index_products_on_product_id on search_index_products  (cost=0.00..8.97 rows=1 width=217)"
"                          Index Cond: (search_index_products.product_id = products.id)"
"              ->  Index Scan using companies_pkey on companies  (cost=0.00..6.88 rows=1 width=25)"
"                    Index Cond: (companies.id = products.company_id)"
"        ->  Hash  (cost=919.18..919.18 rows=26418 width=8)"
"              ->  Seq Scan on product_groups  (cost=0.00..919.18 rows=26418 width=8)"
"  ->  Index Scan using i_product_images_product_id on product_images  (cost=0.00..13.41 rows=5 width=8)"
"        Index Cond: (product_images.product_id = products.id)"
"        Filter: (product_images."position" = 1)"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.000 ms	0.0 %
Bitmap Index Scan	1	0.000 ms	0.0 %
Hash	3	0.000 ms	0.0 %
Hash Left Join	3	0.000 ms	0.0 %
Index Scan	3	0.000 ms	0.0 %
Nested Loop	2	0.000 ms	0.0 %
Nested Loop Left Join	1	0.000 ms	0.0 %
Seq Scan	3	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
companies	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
product_groups	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
product_images	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
products	1	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %
rubrics	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
rubrics_denormalization_tree	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
search_index_products	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 88c

Colorize:

Columns visibility:

Per node type stats

Per table stats