#	exclusive	inclusive	rows x	rows	loops	node
1.	0.001	0.370	↑ 7.0	1	1	→ Result (cost=0.00..51.21 rows=7 width=137) (actual time=0.196..0.370 rows=1 loops=1)
2.	0.001	0.369	↑ 7.0	1	1	→ Append (cost=0.00..51.21 rows=7 width=137) (actual time=0.195..0.369 rows=1 loops=1)
3.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on unique_search (cost=0.00..0.00 rows=1 width=624) (actual time=0.001..0.001 rows=0 loops=1) Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND ((testo)::text = 'nokia'::text) AND (category_id = 84) AND (abs_mod(category_id) = 0))
4.	0.022	0.022	↓ 0.0	0	1	→ Index Scan using idx_unique_search_2006_es_sd_0_testo_and_category_id on unique_search_2006_es_sd_0 unique_search (cost=0.00..8.53 rows=1 width=55) (actual time=0.022..0.022 rows=0 loops=1) Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84)) Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))
5.	0.172	0.172	↑ 1.0	1	1	→ Index Scan using idx_unique_search_2011_es_sd_0_testo_and_category_id on unique_search_2011_es_sd_0 unique_search (cost=0.00..8.56 rows=1 width=54) (actual time=0.171..0.172 rows=1 loops=1) Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84)) Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))
6.	0.040	0.040	↓ 0.0	0	1	→ Index Scan using idx_unique_search_2007_es_sd_0_testo_and_category_id on unique_search_2007_es_sd_0 unique_search (cost=0.00..8.53 rows=1 width=56) (actual time=0.040..0.040 rows=0 loops=1) Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84)) Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))
7.	0.048	0.048	↓ 0.0	0	1	→ Index Scan using idx_unique_search_2008_es_sd_0_testo_and_category_id on unique_search_2008_es_sd_0 unique_search (cost=0.00..8.53 rows=1 width=54) (actual time=0.048..0.048 rows=0 loops=1) Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84)) Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))
8.	0.041	0.041	↓ 0.0	0	1	→ Index Scan using idx_unique_search_2010_es_sd_0_testo_and_category_id on unique_search_2010_es_sd_0 unique_search (cost=0.00..8.53 rows=1 width=56) (actual time=0.041..0.041 rows=0 loops=1) Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84)) Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))
9.	0.044	0.044	↓ 0.0	0	1	→ Index Scan using idx_unique_search_2009_es_sd_0_testo_and_category_id on unique_search_2009_es_sd_0 unique_search (cost=0.00..8.53 rows=1 width=57) (actual time=0.044..0.044 rows=0 loops=1) Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84)) Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))

"Result  (cost=0.00..51.21 rows=7 width=137) (actual time=0.196..0.370 rows=1 loops=1)"
"  ->  Append  (cost=0.00..51.21 rows=7 width=137) (actual time=0.195..0.369 rows=1 loops=1)"
"        ->  Seq Scan on unique_search  (cost=0.00..0.00 rows=1 width=624) (actual time=0.001..0.001 rows=0 loops=1)"
"              Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND ((testo)::text = 'nokia'::text) AND (category_id = 84) AND (abs_mod(category_id) = 0))"
"        ->  Index Scan using idx_unique_search_2006_es_sd_0_testo_and_category_id on unique_search_2006_es_sd_0 unique_search  (cost=0.00..8.53 rows=1 width=55) (actual time=0.022..0.022 rows=0 loops=1)"
"              Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84))"
"              Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))"
"        ->  Index Scan using idx_unique_search_2011_es_sd_0_testo_and_category_id on unique_search_2011_es_sd_0 unique_search  (cost=0.00..8.56 rows=1 width=54) (actual time=0.171..0.172 rows=1 loops=1)"
"              Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84))"
"              Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))"
"        ->  Index Scan using idx_unique_search_2007_es_sd_0_testo_and_category_id on unique_search_2007_es_sd_0 unique_search  (cost=0.00..8.53 rows=1 width=56) (actual time=0.040..0.040 rows=0 loops=1)"
"              Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84))"
"              Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))"
"        ->  Index Scan using idx_unique_search_2008_es_sd_0_testo_and_category_id on unique_search_2008_es_sd_0 unique_search  (cost=0.00..8.53 rows=1 width=54) (actual time=0.048..0.048 rows=0 loops=1)"
"              Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84))"
"              Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))"
"        ->  Index Scan using idx_unique_search_2010_es_sd_0_testo_and_category_id on unique_search_2010_es_sd_0 unique_search  (cost=0.00..8.53 rows=1 width=56) (actual time=0.041..0.041 rows=0 loops=1)"
"              Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84))"
"              Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))"
"        ->  Index Scan using idx_unique_search_2009_es_sd_0_testo_and_category_id on unique_search_2009_es_sd_0 unique_search  (cost=0.00..8.53 rows=1 width=57) (actual time=0.044..0.044 rows=0 loops=1)"
"              Index Cond: (((testo)::text = 'nokia'::text) AND (category_id = 84))"
"              Filter: ((country = 'es'::text) AND (engine = 'sd'::text) AND (abs_mod(category_id) = 0))"
"Total runtime: 0.688 ms"

Per node type stats

node type	count	sum of times	% of query
Append	1	0.001 ms	0.3 %
Index Scan	6	0.367 ms	99.2 %
Result	1	0.001 ms	0.3 %
Seq Scan	1	0.001 ms	0.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
unique_search	1	0.001 ms	0.3 %
Seq Scan	1	0.001 ms	100.0 %
unique_search_2006_es_sd_0	1	0.022 ms	5.9 %
Index Scan	1	0.022 ms	100.0 %
unique_search_2007_es_sd_0	1	0.040 ms	10.8 %
Index Scan	1	0.040 ms	100.0 %
unique_search_2008_es_sd_0	1	0.048 ms	13.0 %
Index Scan	1	0.048 ms	100.0 %
unique_search_2009_es_sd_0	1	0.044 ms	11.9 %
Index Scan	1	0.044 ms	100.0 %
unique_search_2010_es_sd_0	1	0.041 ms	11.1 %
Index Scan	1	0.041 ms	100.0 %
unique_search_2011_es_sd_0	1	0.172 ms	46.5 %
Index Scan	1	0.172 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: LVa

Colorize:

Columns visibility:

Per node type stats

Per table stats