explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1KOS

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

Group (cost=1,117.72..1,117.73 rows=1 width=11) (actual time=45.920..45.925 rows=10 loops=1)

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

Sort (cost=1,117.72..1,117.72 rows=1 width=11) (actual time=45.918..45.919 rows=10 loops=1)

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

Nested Loop (cost=0.00..1,117.71 rows=1 width=11) (actual time=7.597..45.877 rows=10 loops=1)

  • Join Filter: ("position"((hashtag.hashtag_key_word)::text, white.hashtag_key_word) > 0)
  • Rows Removed by Join Filter: 31,868
4. 17.156 21.888 ↓ 198.0 198 1

Nested Loop Left Join (cost=0.00..1,104.43 rows=1 width=10) (actual time=0.363..21.888 rows=198 loops=1)

  • Join Filter: ("position"((hashtag.hashtag_key_word)::text, black.hashtag_key_word) > 0)
  • Rows Removed by Join Filter: 62,470
  • Filter: (black.id_outfit_item_hashtag_filter IS NULL)
  • Rows Removed by Filter: 54
5. 0.063 0.063 ↓ 1.0 203 1

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

  • Filter: (deleted_at IS NULL)
6. 4.538 4.669 ↑ 1.0 308 203

Materialize (cost=0.00..12.40 rows=308 width=18) (actual time=0.000..0.023 rows=308 loops=203)

7. 0.131 0.131 ↑ 1.0 308 1

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

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'black'::hashtag_filter_type))
  • Rows Removed by Filter: 161
8. 14.256 14.256 ↑ 1.0 161 198

Seq Scan on outfit_item_hashtag_filter white (cost=0.00..10.86 rows=161 width=21) (actual time=0.003..0.072 rows=161 loops=198)

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'white'::hashtag_filter_type))
  • Rows Removed by Filter: 308
Planning time : 0.229 ms
Execution time : 45.994 ms