explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YPb7 : divisions

Settings
# exclusive inclusive rows x rows loops node
1. 54.005 139.843 ↓ 4.9 2,390 1

Nested Loop (cost=0.86..1,853.52 rows=486 width=1,172) (actual time=0.193..139.843 rows=2,390 loops=1)

  • Buffers: shared hit=6,084 read=1,402
2. 34.084 54.768 ↓ 4.9 2,390 1

Nested Loop (cost=0.57..1,654.25 rows=486 width=4) (actual time=0.146..54.768 rows=2,390 loops=1)

  • Buffers: shared hit=3 read=310
3. 0.044 0.044 ↑ 1.0 1 1

Index Only Scan using unique_user_division on users_divisions ud (cost=0.28..8.29 rows=1 width=4) (actual time=0.03..0.044 rows=1 loops=1)

  • Index Cond: (ud.user_id = 9,763)
  • Heap Fetches: 1
  • Buffers: shared read=3
4. 20.640 20.640 ↓ 3.1 2,390 1

Index Only Scan using divisions_styles_unique_idx on divisions_styles ds (cost=0.29..1,638.3 rows=765 width=8) (actual time=0.091..20.64 rows=2,390 loops=1)

  • Index Cond: (ds.division_id = ud.division_id)
  • Buffers: shared hit=3 read=307
5. 31.070 31.070 ↑ 1.0 1 2,390

Index Scan using styles_id_incl_designer_id_idx on styles s (cost=0.29..0.41 rows=1 width=1,172) (actual time=0.013..0.013 rows=1 loops=2,390)

  • Index Cond: (s.id = ds.style_id)
  • Buffers: shared hit=6,081 read=1,092
Planning time : 10.845 ms
Execution time : 156.783 ms