explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SHj6

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 41.274 ↑ 1.1 10 1

Group (cost=2,741.31..2,741.85 rows=11 width=11) (actual time=41.269..41.274 rows=10 loops=1)

  • Group Key: hashtag.id_hashtag, white.ss_category_name, white.hashtag_filter_group_name
2. 0.021 41.269 ↑ 5.4 10 1

Sort (cost=2,741.31..2,741.44 rows=54 width=11) (actual time=41.267..41.269 rows=10 loops=1)

  • Sort Key: hashtag.id_hashtag, white.ss_category_name, white.hashtag_filter_group_name
  • Sort Method: quicksort Memory: 25kB
3. 8.143 41.248 ↑ 5.4 10 1

Nested Loop (cost=0.00..2,739.75 rows=54 width=11) (actual time=5.484..41.248 rows=10 loops=1)

  • Join Filter: (strpos((hashtag.hashtag_key_word)::text, white.hashtag_key_word) > 0)
  • Rows Removed by Join Filter: 31,868
4. 0.301 21.819 ↓ 198.0 198 1

Seq Scan on hashtag (cost=0.00..2,726.48 rows=1 width=10) (actual time=0.119..21.819 rows=198 loops=1)

  • Filter: ((SubPlan 1) = 0)
  • Rows Removed by Filter: 5
5.          

SubPlan (for Seq Scan)

6. 0.203 21.518 ↑ 1.0 1 203

Aggregate (cost=13.47..13.48 rows=1 width=8) (actual time=0.106..0.106 rows=1 loops=203)

7. 21.315 21.315 ↓ 0.0 0 203

Seq Scan on outfit_item_hashtag_filter black (cost=0.00..13.21 rows=103 width=4) (actual time=0.103..0.105 rows=0 loops=203)

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'black'::hashtag_filter_type) AND (strpos((hashtag.hashtag_key_word)::text, hashtag_key_word) > 0))
  • Rows Removed by Filter: 469
8. 11.286 11.286 ↑ 1.0 161 198

Seq Scan on outfit_item_hashtag_filter white (cost=0.00..10.86 rows=161 width=21) (actual time=0.002..0.057 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.149 ms
Execution time : 41.308 ms