explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3VBS

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 3,019.756 ↑ 39.9 36 1

Sort (cost=367,048.71..367,052.31 rows=1,437 width=31) (actual time=3,019.755..3,019.756 rows=36 loops=1)

  • Sort Key: brand.name
  • Sort Method: quicksort Memory: 27kB
2. 527.732 3,019.670 ↑ 39.9 36 1

GroupAggregate (cost=0.00..366,973.35 rows=1,437 width=31) (actual time=44.781..3,019.670 rows=36 loops=1)

3. 569.512 2,491.938 ↑ 2.3 1,527,392 1

Nested Loop (cost=0.00..349,657.73 rows=3,460,251 width=31) (actual time=0.089..2,491.938 rows=1,527,392 loops=1)

4. 108.338 307.304 ↓ 1.1 807,561 1

Nested Loop (cost=0.00..32,939.44 rows=763,229 width=31) (actual time=0.054..307.304 rows=807,561 loops=1)

5. 1.558 11.002 ↓ 1.1 6,713 1

Nested Loop (cost=0.00..1,383.47 rows=6,344 width=31) (actual time=0.037..11.002 rows=6,713 loops=1)

6. 0.824 3.720 ↑ 1.4 954 1

Nested Loop (cost=0.00..553.57 rows=1,358 width=31) (actual time=0.023..3.720 rows=954 loops=1)

7. 0.662 1.499 ↑ 1.0 1,397 1

Merge Join (cost=0.00..68.83 rows=1,397 width=31) (actual time=0.013..1.499 rows=1,397 loops=1)

  • Merge Cond: (model.parent_id = brand.id)
8. 0.430 0.430 ↑ 1.0 1,398 1

Index Scan using vehicle_tree_parent_id on vehicle_tree model (cost=0.00..37.81 rows=1,437 width=8) (actual time=0.005..0.430 rows=1,398 loops=1)

9. 0.407 0.407 ↑ 1.0 1,403 1

Index Scan using adsaa2z on vehicle_tree brand (cost=0.00..36.45 rows=1,437 width=27) (actual time=0.003..0.407 rows=1,403 loops=1)

10. 1.397 1.397 ↑ 3.0 1 1,397

Index Scan using vehicle_tree_parent_id on vehicle_tree model_type (cost=0.00..0.31 rows=3 width=8) (actual time=0.001..0.001 rows=1 loops=1,397)

  • Index Cond: (parent_id = model.id)
11. 5.724 5.724 ↑ 1.0 7 954

Index Scan using vehicle_vehicle_model_type_id on vehicle v (cost=0.00..0.52 rows=7 width=8) (actual time=0.003..0.006 rows=7 loops=954)

  • Index Cond: (vehicle_model_type_id = model_type.id)
12. 187.964 187.964 ↑ 1.2 120 6,713

Index Scan using vggv on vehicle_grup_id rel (cost=0.00..3.19 rows=143 width=8) (actual time=0.004..0.028 rows=120 loops=6,713)

  • Index Cond: (vehicle_id = v.id)
13. 1,615.122 1,615.122 ↑ 2.5 2 807,561

Index Scan using product_grup_id on product (cost=0.00..0.35 rows=5 width=8) (actual time=0.002..0.002 rows=2 loops=807,561)

  • Index Cond: (grup_id = rel.grup_id)
  • Filter: active