explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iJ6Oc

Settings
# exclusive inclusive rows x rows loops node
1. 8.644 81.683 ↑ 3.0 8,402 1

HashAggregate (cost=70,363.26..70,617.5 rows=25,424 width=8) (actual time=78.888..81.683 rows=8,402 loops=1)

  • Group Key: s.id, ud.user_id
  • Buffers: shared hit=35,953
2. 1.118 73.039 ↑ 3.0 8,411 1

Append (cost=0.86..70,236.14 rows=25,424 width=8) (actual time=0.036..73.039 rows=8,411 loops=1)

  • Buffers: shared hit=35,953
3. 1.993 13.277 ↓ 4.6 2,378 1

Nested Loop (cost=0.86..634.48 rows=513 width=8) (actual time=0.035..13.277 rows=2,378 loops=1)

  • Buffers: shared hit=10,307
4. 0.359 1.772 ↓ 4.6 2,378 1

Nested Loop (cost=0.43..353.22 rows=513 width=8) (actual time=0.025..1.772 rows=2,378 loops=1)

  • Buffers: shared hit=780
5. 0.034 0.034 ↑ 1.0 1 1

Seq Scan on users_divisions ud (cost=0..6.75 rows=1 width=8) (actual time=0.01..0.034 rows=1 loops=1)

  • Filter: (ud.user_id = 709,127)
  • Buffers: shared hit=3
6. 1.379 1.379 ↓ 2.9 2,378 1

Index Only Scan using divisions_styles_unique_1_idx on divisions_styles ds (cost=0.43..338.13 rows=834 width=8) (actual time=0.012..1.379 rows=2,378 loops=1)

  • Index Cond: (ds.division_id = ud.division_id)
  • Heap Fetches: 2,378
  • Buffers: shared hit=777
7. 9.512 9.512 ↑ 1.0 1 2,378

Index Only Scan using styles_id_incl_designer_id_idx on styles s (cost=0.43..0.55 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=2,378)

  • Index Cond: (s.id = ds.style_id)
  • Heap Fetches: 2,378
  • Buffers: shared hit=9,527
8. 5.455 58.644 ↑ 4.1 6,033 1

Nested Loop (cost=379.61..69,220.29 rows=24,911 width=8) (actual time=3.664..58.644 rows=6,033 loops=1)

  • Buffers: shared hit=25,646
9. 2.248 23.024 ↑ 4.1 6,033 1

Nested Loop (cost=379.17..57,072.82 rows=24,911 width=8) (actual time=3.624..23.024 rows=6,033 loops=1)

  • Buffers: shared hit=4,243
10. 0.012 0.012 ↑ 1.0 2 1

Index Only Scan using unique_user_category on users_categories uc (cost=0.28..11.74 rows=2 width=8) (actual time=0.008..0.012 rows=2 loops=1)

  • Index Cond: (uc.user_id = 709,127)
  • Heap Fetches: 2
  • Buffers: shared hit=4
11. 19.944 20.764 ↑ 5.1 3,016 2

Bitmap Heap Scan on categories_styles cs (cost=378.9..28,377.68 rows=15,286 width=8) (actual time=2.187..10.382 rows=3,016 loops=2)

  • Heap Blocks: exact=4,206
  • Buffers: shared hit=4,239
12. 0.820 0.820 ↑ 5.0 3,086 2

Bitmap Index Scan on categories_styles_category_id_idx (cost=0..375.08 rows=15,286 width=0) (actual time=0.41..0.41 rows=3,086 loops=2)

  • Index Cond: (cs.category_id = uc.category_id)
  • Buffers: shared hit=33
13. 30.165 30.165 ↑ 1.0 1 6,033

Index Only Scan using styles_id_incl_designer_id_idx on styles s_1 (cost=0.43..0.49 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=6,033)

  • Index Cond: (s_1.id = cs.style_id)
  • Heap Fetches: 1,269
  • Buffers: shared hit=21,403
Planning time : 0.848 ms
Execution time : 82.214 ms