explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bQ8T

Settings
# exclusive inclusive rows x rows loops node
1. 1.363 18.452 ↓ 3.6 57 1

Nested Loop (cost=8.59..64.32 rows=16 width=1,187) (actual time=1.352..18.452 rows=57 loops=1)

  • Output: s.id, s.designer_id, s.fabrication_id, s.print_all_images, s.name, s.number, s.description, s.sizes_available, s.prepack_quantities, s.sizes, s.sizes_run, s.model_height, s.measurements, s.country_of_origin, s.minimum_order_quantity, s.best_seller, s.deleted, s.created, s.modified, s.show_as_range, s.identifier, s.label, s.label_value, s.size_run_id, s.mod_user_token_id, s.assortment_plan_id, s.source_of_materials, s.heel_height, s.contains_fur, s.silhouette_id, s.made_to_order, s.updated_at, s.soft_deleted_at
  • Inner Unique: true
  • Buffers: shared hit=195
2. 8.091 16.291 ↓ 3.6 57 1

Hash Join (cost=8.30..43.28 rows=16 width=4) (actual time=1.313..16.291 rows=57 loops=1)

  • Output: ds.style_id
  • Hash Cond: (ds.division_id = ud.division_id)
  • Buffers: shared hit=24
3. 8.147 8.147 ↑ 1.0 1,005 1

Seq Scan on joor_web.divisions_styles ds (cost=0.00..31.05 rows=1,005 width=8) (actual time=0.647..8.147 rows=1,005 loops=1)

  • Output: ds.id, ds.style_id, ds.division_id, ds.created, ds.modified, ds.deleted, ds.mod_user, ds.mod_user_token_id, ds.updated_at
  • Buffers: shared hit=21
4. 0.023 0.053 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=4) (actual time=0.046..0.053 rows=1 loops=1)

  • Output: ud.division_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
5. 0.030 0.030 ↑ 1.0 1 1

Index Scan using users_divisions_user_id_b590bd26 on joor_web.users_divisions ud (cost=0.28..8.29 rows=1 width=4) (actual time=0.015..0.030 rows=1 loops=1)

  • Output: ud.division_id
  • Index Cond: (ud.user_id = 7,819)
  • Buffers: shared hit=3
6. 0.798 0.798 ↑ 1.0 1 57

Index Scan using styles_id_incl_designer_id_idx on joor_web.styles s (cost=0.28..1.31 rows=1 width=1,187) (actual time=0.014..0.014 rows=1 loops=57)

  • Output: s.id, s.designer_id, s.fabrication_id, s.print_all_images, s.name, s.number, s.description, s.sizes_available, s.prepack_quantities, s.sizes, s.sizes_run, s.model_height, s.measurements, s.country_of_origin, s.minimum_order_quantity, s.best_seller, s.deleted, s.created, s.modified, s.show_as_range, s.identifier, s.label, s.label_value, s.size_run_id, s.mod_user_token_id, s.assortment_plan_id, s.source_of_materials, s.heel_height, s.contains_fur, s.silhouette_id, s.made_to_order, s.updated_at, s.soft_deleted_at
  • Index Cond: (s.id = ds.style_id)
  • Buffers: shared hit=171
Planning time : 9.472 ms
Execution time : 19.048 ms