explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nhe8

Settings
# exclusive inclusive rows x rows loops node
1. 1.736 634.135 ↑ 4.5 2 1

Unique (cost=1.27..5,039.87 rows=9 width=531) (actual time=0.857..634.135 rows=2 loops=1)

  • Buffers: shared hit=1,239,331 dirtied=15
2. 0.000 632.399 ↓ 503.4 19,131 1

Nested Loop (cost=1.27..5,039.78 rows=38 width=531) (actual time=0.856..632.399 rows=19,131 loops=1)

  • Buffers: shared hit=1,239,331 dirtied=15
3. 34.082 110.622 ↓ 104.0 289,266 1

Nested Loop (cost=0.84..3,603.96 rows=2,781 width=66) (actual time=0.702..110.622 rows=289,266 loops=1)

  • Buffers: shared hit=80,253 dirtied=6
4. 0.745 0.780 ↓ 2.0 2 1

Nested Loop Left Join (cost=0.42..44.57 rows=1 width=62) (actual time=0.688..0.780 rows=2 loops=1)

  • Join Filter: ((t3.msgid)::text = (c0.name)::text)
  • Filter: (COALESCE(t3.search_vector, c0.search_vector) @@ to_tsquery(('english'::cstring)::regconfig, 'Hair:*'::text))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=36
5. 0.017 0.017 ↑ 1.0 9 1

Index Scan using categories_pkey on categories c0 (cost=0.14..36.04 rows=9 width=33) (actual time=0.006..0.017 rows=9 loops=1)

  • Buffers: shared hit=9
6. 0.006 0.018 ↓ 0.0 0 9

Materialize (cost=0.28..6.08 rows=1 width=94) (actual time=0.002..0.002 rows=0 loops=9)

  • Buffers: shared hit=2
7. 0.012 0.012 ↓ 0.0 0 1

Index Scan using translations_domain_locale_msgid_index on translations t3 (cost=0.28..6.08 rows=1 width=94) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((domain)::text = 'categories'::text) AND ((locale)::text = 'en'::text))
  • Filter: (msgid_plural IS NULL)
  • Buffers: shared hit=2
8. 75.760 75.760 ↓ 2.3 144,633 2

Index Only Scan using location_categories_category_id_location_id_index on location_categories l1 (cost=0.42..2,941.43 rows=61,795 width=8) (actual time=0.013..37.880 rows=144,633 loops=2)

  • Index Cond: (category_id = c0.id)
  • Heap Fetches: 112,581
  • Buffers: shared hit=80,217 dirtied=6
9. 578.532 578.532 ↓ 0.0 0 289,266

Index Scan using locations_pkey on locations l2 (cost=0.42..0.52 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=289,266)

  • Index Cond: (id = l1.location_id)
  • Filter: (published AND discoverable AND ((NOT hidden_from_marketplace) OR (hidden_from_marketplace IS NULL)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,159,078 dirtied=9
Planning time : 1.448 ms
Execution time : 634.221 ms