explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PZMQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 13.859 ↓ 10.0 10 1

Group (cost=43.92..43.93 rows=1 width=11) (actual time=13.853..13.859 rows=10 loops=1)

  • Group Key: hashtag.id_hashtag, outfit_item_hashtag_filter.ss_category_name, outfit_item_hashtag_filter.hashtag_filter_group_name
2. 0.026 13.853 ↓ 10.0 10 1

Sort (cost=43.92..43.92 rows=1 width=11) (actual time=13.851..13.853 rows=10 loops=1)

  • Sort Key: hashtag.id_hashtag, outfit_item_hashtag_filter.ss_category_name, outfit_item_hashtag_filter.hashtag_filter_group_name
  • Sort Method: quicksort Memory: 25kB
3. 10.987 13.827 ↓ 10.0 10 1

Nested Loop (cost=14.71..43.91 rows=1 width=11) (actual time=1.141..13.827 rows=10 loops=1)

  • Join Filter: ((hashtag.hashtag_key_word)::text ~~ (('%'::text || outfit_item_hashtag_filter.hashtag_key_word) || '%'::text))
  • Rows Removed by Join Filter: 32,267
4. 0.062 0.296 ↓ 159.0 159 1

Hash Left Join (cost=14.71..36.35 rows=1 width=21) (actual time=0.175..0.296 rows=159 loops=1)

  • Hash Cond: (outfit_item_hashtag_filter.hashtag_key_word = outfit_item_hashtag_filter_1.hashtag_key_word)
  • Filter: (outfit_item_hashtag_filter_1.id_outfit_item_hashtag_filter IS NULL)
  • Rows Removed by Filter: 2
5. 0.075 0.075 ↑ 1.0 161 1

Seq Scan on outfit_item_hashtag_filter (cost=0.00..10.86 rows=161 width=21) (actual time=0.008..0.075 rows=161 loops=1)

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'white'::hashtag_filter_type))
  • Rows Removed by Filter: 308
6. 0.075 0.159 ↑ 1.0 308 1

Hash (cost=10.86..10.86 rows=308 width=18) (actual time=0.159..0.159 rows=308 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
7. 0.084 0.084 ↑ 1.0 308 1

Seq Scan on outfit_item_hashtag_filter outfit_item_hashtag_filter_1 (cost=0.00..10.86 rows=308 width=18) (actual time=0.022..0.084 rows=308 loops=1)

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'black'::hashtag_filter_type))
  • Rows Removed by Filter: 161
8. 2.544 2.544 ↓ 1.0 203 159

Seq Scan on hashtag (cost=0.00..4.02 rows=202 width=10) (actual time=0.002..0.016 rows=203 loops=159)

Planning time : 0.428 ms
Execution time : 13.904 ms