explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Pkw

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 16.883 ↑ 8.2 10 1

Group (cost=357.74..358.56 rows=82 width=11) (actual time=16.877..16.883 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.037 16.877 ↑ 8.2 10 1

Sort (cost=357.74..357.94 rows=82 width=11) (actual time=16.875..16.877 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. 13.961 16.840 ↑ 8.2 10 1

Nested Loop (cost=11.63..355.13 rows=82 width=11) (actual time=3.104..16.840 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.037 0.037 ↓ 1.0 203 1

Seq Scan on hashtag (cost=0.00..4.02 rows=202 width=10) (actual time=0.009..0.037 rows=203 loops=1)

5. 2.369 2.842 ↓ 2.0 159 203

Materialize (cost=11.63..24.07 rows=81 width=21) (actual time=0.001..0.014 rows=159 loops=203)

6. 0.351 0.473 ↓ 2.0 159 1

Seq Scan on outfit_item_hashtag_filter (cost=11.63..23.67 rows=81 width=21) (actual time=0.265..0.473 rows=159 loops=1)

  • Filter: ((deleted_at IS NULL) AND (NOT (hashed SubPlan 1)) AND (hashtag_filter_type = 'white'::hashtag_filter_type))
  • Rows Removed by Filter: 310
7.          

SubPlan (for Seq Scan)

8. 0.122 0.122 ↑ 1.0 308 1

Seq Scan on outfit_item_hashtag_filter outfit_item_hashtag_filter_1 (cost=0.00..10.86 rows=308 width=14) (actual time=0.034..0.122 rows=308 loops=1)

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'black'::hashtag_filter_type))
  • Rows Removed by Filter: 161
Planning time : 0.266 ms
Execution time : 16.938 ms