explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GPY

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.020 ↓ 0.0 0 1

Nested Loop Left Join (cost=52.66..68.73 rows=1 width=147) (actual time=0.020..0.020 rows=0 loops=1)

2. 0.000 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=52.51..60.55 rows=1 width=143) (actual time=0.019..0.019 rows=0 loops=1)

3. 0.001 0.019 ↓ 0.0 0 1

Limit (cost=52.35..52.36 rows=1 width=139) (actual time=0.019..0.019 rows=0 loops=1)

4. 0.007 0.018 ↓ 0.0 0 1

Sort (cost=52.35..52.36 rows=1 width=139) (actual time=0.018..0.018 rows=0 loops=1)

  • Sort Key: outfit.outfit_post_datetime DESC
  • Sort Method: quicksort Memory: 25kB
5. 0.001 0.011 ↓ 0.0 0 1

GroupAggregate (cost=52.32..52.34 rows=1 width=139) (actual time=0.011..0.011 rows=0 loops=1)

  • Group Key: outfit.id_outfit
6. 0.007 0.010 ↓ 0.0 0 1

Sort (cost=52.32..52.33 rows=1 width=135) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: outfit.id_outfit
  • Sort Method: quicksort Memory: 25kB
7. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=19.12..52.31 rows=1 width=135) (actual time=0.003..0.003 rows=0 loops=1)

8. 0.001 0.003 ↓ 0.0 0 1

Hash Join (cost=18.70..44.57 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond: (rel_outfit_hashtag.id_hashtag = hashtag.id_hashtag)
9. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=4.33..29.79 rows=108 width=12) (actual time=0.002..0.002 rows=0 loops=1)

10. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=4.18..23.43 rows=17 width=4) (actual time=0.002..0.002 rows=0 loops=1)

11. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on item (cost=0.00..10.75 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((im_name)::text ~~ '%%-45'::text) AND ((brand_name)::text = 'GU'::text))
12. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on detection_item (cost=4.18..12.64 rows=4 width=8) (never executed)

  • Recheck Cond: (id_item = item.id_item)
13. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on index_detection_item_id_item (cost=0.00..4.18 rows=4 width=0) (never executed)

  • Index Cond: (id_item = item.id_item)
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using outfit_hashtag_idx on rel_outfit_hashtag (cost=0.15..0.31 rows=6 width=8) (never executed)

  • Index Cond: (id_outfit = detection_item.id_outfit)
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.35..14.35 rows=1 width=4) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on hashtag (cost=0.00..14.35 rows=1 width=4) (never executed)

  • Filter: (lower((hashtag_key_word)::text) = 'summer'::text)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using outfit_pkey on outfit (cost=0.42..7.74 rows=1 width=131) (never executed)

  • Index Cond: (id_outfit = rel_outfit_hashtag.id_outfit)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using outfit_comment_count_id_outfit_key on outfit_comment_count (cost=0.15..8.17 rows=1 width=8) (never executed)

  • Index Cond: (id_outfit = outfit.id_outfit)
  • Filter: (deleted_at IS NULL)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_outfit on outfit_star_count (cost=0.15..8.17 rows=1 width=8) (never executed)

  • Index Cond: (id_outfit = outfit.id_outfit)
  • Filter: (deleted_at IS NULL)
Planning time : 1.474 ms
Execution time : 0.160 ms