explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0PbC

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 46.627 ↓ 10.0 10 1

Group (cost=1,273.66..1,273.68 rows=1 width=11) (actual time=46.623..46.627 rows=10 loops=1)

  • Group Key: hashtag.id_hashtag, white.ss_category_name, white.hashtag_filter_group_name
2. 0.444 46.622 ↓ 10.0 10 1

Sort (cost=1,273.66..1,273.67 rows=1 width=11) (actual time=46.621..46.622 rows=10 loops=1)

  • Sort Key: hashtag.id_hashtag, white.ss_category_name, white.hashtag_filter_group_name
  • Sort Method: quicksort Memory: 25kB
3. 21.865 46.178 ↓ 10.0 10 1

Nested Loop (cost=0.00..1,273.65 rows=1 width=11) (actual time=6.971..46.178 rows=10 loops=1)

  • Join Filter: ((hashtag.hashtag_key_word)::text ~~ (('%'::text || white.hashtag_key_word) || '%'::text))
  • Rows Removed by Join Filter: 31,868
4. 20.286 24.313 ↓ 198.0 198 1

Nested Loop Left Join (cost=0.00..1,259.97 rows=1 width=10) (actual time=0.745..24.313 rows=198 loops=1)

  • Join Filter: ((hashtag.hashtag_key_word)::text ~~ (('%'::text || black.hashtag_key_word) || '%'::text))
  • Rows Removed by Join Filter: 62,172
  • Filter: (black.id_outfit_item_hashtag_filter IS NULL)
  • Rows Removed by Filter: 44
5. 0.189 0.189 ↑ 1.0 202 1

Seq Scan on hashtag (cost=0.00..4.02 rows=202 width=10) (actual time=0.128..0.189 rows=202 loops=1)

  • Filter: (deleted_at IS NULL)
6. 3.397 3.838 ↑ 1.0 308 202

Materialize (cost=0.00..12.40 rows=308 width=18) (actual time=0.001..0.019 rows=308 loops=202)

7. 0.441 0.441 ↑ 1.0 308 1

Seq Scan on outfit_item_hashtag_filter black (cost=0.00..10.86 rows=308 width=18) (actual time=0.152..0.441 rows=308 loops=1)

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'black'::hashtag_filter_type))
  • Rows Removed by Filter: 161