explain.depesz.com

A tool for finding a real cause for slow queries.

Result: LVa

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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))