explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iBiX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=103.10..828.61 rows=860 width=135) (actual rows= loops=)

  • Hash Cond: (motors_pieces_values_1.piece_brand_id = motors_pieces_brands_1.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on motors_pieces_values motors_pieces_values_1 (cost=0.00..553.66 rows=32,066 width=29) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=102.15..102.15 rows=76 width=135) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=36.42..102.15 rows=76 width=135) (actual rows= loops=)

  • Hash Cond: (motors_pieces_brands_1.piece_id = motors_pieces.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on motors_pieces_brands motors_pieces_brands_1 (cost=0.00..54.34 rows=2,834 width=30) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=35.50..35.50 rows=74 width=105) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on motors_pieces (cost=4.57..35.50 rows=74 width=105) (actual rows= loops=)

  • Recheck Cond: (1 = car_id)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on car_id_idx (cost=0.00..4.55 rows=74 width=0) (actual rows= loops=)

  • Index Cond: (1 = car_id)