explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H8Ov

Settings
# exclusive inclusive rows x rows loops node
1. 2,214.746 3,572.732 ↓ 2.5 2,225,121 1

Hash Right Join (cost=21,527.94..120,379.48 rows=907,458 width=178) (actual time=1,507.448..3,572.732 rows=2,225,121 loops=1)

  • Hash Cond: (vehicleatt1_.vehicle_id = vehicle0_.id)
2. 788.827 788.827 ↑ 1.0 2,267,962 1

Seq Scan on vehicle_attribute vehicleatt1_ (cost=0.00..44,465.10 rows=2,275,710 width=38) (actual time=0.008..788.827 rows=2,267,962 loops=1)

3. 155.279 569.159 ↓ 3.7 219,107 1

Hash (cost=19,564.44..19,564.44 rows=59,480 width=140) (actual time=569.159..569.159 rows=219,107 loops=1)

  • Buckets: 32768 (originally 32768) Batches: 16 (originally 4) Memory Usage: 3841kB
4. 145.572 413.880 ↓ 3.7 219,107 1

Hash Left Join (cost=541.49..19,564.44 rows=59,480 width=140) (actual time=19.943..413.880 rows=219,107 loops=1)

  • Hash Cond: (capabiliti2_.capabilities_id = capability3_.id)
5. 107.473 260.954 ↓ 3.7 219,107 1

Nested Loop Left Join (cost=191.14..18,396.24 rows=59,480 width=105) (actual time=12.523..260.954 rows=219,107 loops=1)

6. 19.067 69.481 ↓ 1.8 2,000 1

Hash Semi Join (cost=190.71..4,762.96 rows=1,094 width=89) (actual time=12.493..69.481 rows=2,000 loops=1)

  • Hash Cond: ((vehicle0_.platform_identifier)::text = (vehicle.platform_identifier)::text)
7. 37.952 37.952 ↓ 1.1 64,407 1

Seq Scan on vehicle vehicle0_ (cost=0.00..4,401.49 rows=60,414 width=89) (actual time=0.011..37.952 rows=64,407 loops=1)

  • Filter: ((tenant)::text = 'mb-prod'::text)
  • Rows Removed by Filter: 89629
8. 0.569 12.462 ↑ 1.0 2,000 1

Hash (cost=165.71..165.71 rows=2,000 width=32) (actual time=12.462..12.462 rows=2,000 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 143kB
9. 0.804 11.893 ↑ 1.0 2,000 1

Limit (cost=0.00..145.71 rows=2,000 width=32) (actual time=0.008..11.893 rows=2,000 loops=1)

10. 11.089 11.089 ↑ 30.2 2,000 1

Seq Scan on vehicle (cost=0.00..4,401.49 rows=60,414 width=32) (actual time=0.006..11.089 rows=2,000 loops=1)

  • Filter: ((tenant)::text = 'mb-prod'::text)
  • Rows Removed by Filter: 83408
11. 84.000 84.000 ↑ 1.8 110 2,000

Index Scan using vehicle_capability_vehicles_id_idx on vehicle_capability capabiliti2_ (cost=0.43..10.51 rows=195 width=16) (actual time=0.005..0.042 rows=110 loops=2,000)

  • Index Cond: (vehicle0_.id = vehicles_id)
12. 4.069 7.354 ↓ 1.0 11,201 1

Hash (cost=214.60..214.60 rows=10,860 width=35) (actual time=7.354..7.354 rows=11,201 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 870kB
13. 3.285 3.285 ↓ 1.0 11,201 1

Seq Scan on capability capability3_ (cost=0.00..214.60 rows=10,860 width=35) (actual time=0.005..3.285 rows=11,201 loops=1)