explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CkPY

Settings
# exclusive inclusive rows x rows loops node
1. 76.106 226.560 ↓ 6.0 157,310 1

Nested Loop Left Join (cost=5,803.09..31,736.63 rows=26,223 width=172) (actual time=25.753..226.560 rows=157,310 loops=1)

2. 9.445 74.584 ↓ 7.8 15,174 1

Hash Left Join (cost=5,802.66..7,766.00 rows=1,942 width=137) (actual time=25.741..74.584 rows=15,174 loops=1)

  • Hash Cond: (capabiliti2_.capabilities_id = capability3_.id)
3. 27.751 62.431 ↓ 7.8 15,174 1

Hash Right Join (cost=5,660.98..7,597.61 rows=1,942 width=105) (actual time=23.018..62.431 rows=15,174 loops=1)

  • Hash Cond: (capabiliti2_.vehicles_id = vehicle0_.id)
4. 21.184 21.184 ↑ 1.0 92,888 1

Seq Scan on vehicle_capability capabiliti2_ (cost=0.00..1,568.88 rows=92,888 width=16) (actual time=0.005..21.184 rows=92,888 loops=1)

5. 1.018 13.496 ↓ 1.1 2,000 1

Hash (cost=5,637.48..5,637.48 rows=1,880 width=89) (actual time=13.496..13.496 rows=2,000 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 261kB
6. 12.478 12.478 ↓ 1.1 2,000 1

Index Scan using vehicle_tenant_platform_id on vehicle vehicle0_ (cost=0.42..5,637.48 rows=1,880 width=89) (actual time=0.016..12.478 rows=2,000 loops=1)

  • Index Cond: (((tenant)::text = 'mb-int'::text) AND ((platform_identifier)::text = ANY ('{DBD357420FFD7BE2924C7DF819A0DBFA,9FD861DECF74EBF2D73032A0E156CCBF,108592BCF94120548726399DA4BABE19,B12E40D1875FF902FF0E027ED7162D93,4BBD7BF3E (...)
7. 1.429 2.708 ↓ 1.0 4,496 1

Hash (cost=85.75..85.75 rows=4,475 width=32) (actual time=2.708..2.708 rows=4,496 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 350kB
8. 1.279 1.279 ↓ 1.0 4,496 1

Seq Scan on capability capability3_ (cost=0.00..85.75 rows=4,475 width=32) (actual time=0.004..1.279 rows=4,496 loops=1)

9. 75.870 75.870 ↑ 1.4 10 15,174

Index Scan using vehicle_attribute_vehicle_id_idx on vehicle_attribute vehicleatt1_ (cost=0.43..12.20 rows=14 width=35) (actual time=0.002..0.005 rows=10 loops=15,174)

  • Index Cond: (vehicle0_.id = vehicle_id)