explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uRUC

Settings
# exclusive inclusive rows x rows loops node
1. 790.495 2,275.210 ↓ 5,308.0 5,308 1

Nested Loop Left Join (cost=32,754.72..82,119.83 rows=1 width=11) (actual time=1,130.742..2,275.210 rows=5,308 loops=1)

  • Join Filter: ((hashtag.hashtag_key_word)::text ~~ (('%'::text || black.hashtag_key_word) || '%'::text))
  • Rows Removed by Join Filter: 1,698,598
  • Filter: (black.id_outfit_item_hashtag_filter IS NULL)
  • Rows Removed by Filter: 2,486
2. 3.640 1,136.766 ↑ 1.4 5,523 1

Unique (cost=32,754.72..32,834.58 rows=7,986 width=33) (actual time=1,130.252..1,136.766 rows=5,523 loops=1)

3. 9.140 1,133.126 ↑ 1.3 6,374 1

Sort (cost=32,754.72..32,774.68 rows=7,986 width=33) (actual time=1,130.249..1,133.126 rows=6,374 loops=1)

  • Sort Key: hashtag.id_hashtag, white.ss_category_name, white.hashtag_filter_group_name
  • Sort Method: quicksort Memory: 854kB
4. 791.986 1,123.986 ↑ 1.3 6,374 1

Nested Loop (cost=0.00..32,237.10 rows=7,986 width=33) (actual time=0.590..1,123.986 rows=6,374 loops=1)

  • Join Filter: ((hashtag.hashtag_key_word)::text ~~ (('%'::text || white.hashtag_key_word) || '%'::text))
  • Rows Removed by Join Filter: 1,591,229
5. 4.541 4.541 ↓ 1.0 9,923 1

Seq Scan on hashtag (cost=0.00..280.21 rows=9,921 width=26) (actual time=0.025..4.541 rows=9,923 loops=1)

  • Filter: (deleted_at IS NULL)
6. 327.345 327.459 ↑ 1.0 161 9,923

Materialize (cost=0.00..11.67 rows=161 width=21) (actual time=0.000..0.033 rows=161 loops=9,923)

7. 0.114 0.114 ↑ 1.0 161 1

Seq Scan on outfit_item_hashtag_filter white (cost=0.00..10.86 rows=161 width=21) (actual time=0.014..0.114 rows=161 loops=1)

  • Filter: ((deleted_at IS NULL) AND (hashtag_filter_type = 'white'::hashtag_filter_type))
  • Rows Removed by Filter: 308
8. 347.799 347.949 ↑ 1.0 308 5,523

Materialize (cost=0.00..12.40 rows=308 width=18) (actual time=0.000..0.063 rows=308 loops=5,523)

9. 0.150 0.150 ↑ 1.0 308 1

Seq Scan on outfit_item_hashtag_filter black (cost=0.00..10.86 rows=308 width=18) (actual time=0.038..0.150 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.718 ms
Execution time : 2,276.317 ms