explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iXgv : skus with inventory

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.079 ↓ 0.0 0 1

Hash Join (cost=10.15..251.48 rows=1 width=11) (actual time=0.079..0.079 rows=0 loops=1)

  • Filter: (wii.id IS NULL)
  • Buffers: shared hit=27
2. 0.003 0.050 ↑ 567.8 5 1

Nested Loop (cost=1.56..210.93 rows=2,839 width=15) (actual time=0.035..0.05 rows=5 loops=1)

  • Buffers: shared hit=17
3. 0.017 0.017 ↑ 33.4 5 1

Index Scan using style_sizes_style_id_idx on style_sizes sz (cost=0.56..157.93 rows=167 width=11) (actual time=0.013..0.017 rows=5 loops=1)

  • Index Cond: (sz.style_id = 6,567,478)
  • Filter: (sz.deleted = 0)
  • Buffers: shared hit=7
4. 0.002 0.030 ↑ 17.0 1 5

Materialize (cost=0.99..17.56 rows=17 width=8) (actual time=0.004..0.006 rows=1 loops=5)

  • Buffers: shared hit=10
5. 0.001 0.028 ↑ 17.0 1 1

Nested Loop (cost=0.99..17.48 rows=17 width=8) (actual time=0.019..0.028 rows=1 loops=1)

  • Buffers: shared hit=10
6. 0.019 0.019 ↑ 1.0 1 1

Index Only Scan using styles_id_incl_designer_id_idx on styles s (cost=0.43..8.45 rows=1 width=4) (actual time=0.01..0.019 rows=1 loops=1)

  • Index Cond: (s.id = 6,567,478)
  • Heap Fetches: 6
  • Buffers: shared hit=5
7. 0.008 0.008 ↑ 17.0 1 1

Index Only Scan using style_colors_style_id_cover_idx on style_colors sc (cost=0.56..8.86 rows=17 width=8) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (sc.style_id = 6,567,478)
  • Buffers: shared hit=5
8. 0.003 0.020 ↓ 5.0 5 1

Hash (cost=8.58..8.58 rows=1 width=20) (actual time=0.02..0.02 rows=5 loops=1)

  • Buffers: shared hit=10
9. 0.017 0.017 ↓ 5.0 5 1

Index Only Scan using wip_inventory_items_inventory_style_color_size on wip_inventory_items wii (cost=0.56..8.58 rows=1 width=20) (actual time=0.012..0.017 rows=5 loops=1)

  • Index Cond: ((wii.wip_inventory_id = 141,805) AND (wii.style_id = 6,567,478))
  • Heap Fetches: 5
  • Buffers: shared hit=10
Planning time : 0.658 ms
Execution time : 0.124 ms