explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bahC

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.322 ↑ 1.0 1 1

Nested Loop Left Join (cost=16.29..19.77 rows=1 width=3,136) (actual time=0.318..0.322 rows=1 loops=1)

2. 0.006 0.313 ↑ 1.0 1 1

Nested Loop Left Join (cost=16.00..19.43 rows=1 width=2,794) (actual time=0.310..0.313 rows=1 loops=1)

3. 0.019 0.305 ↑ 1.0 1 1

Nested Loop Left Join (cost=15.71..19.12 rows=1 width=2,786) (actual time=0.302..0.305 rows=1 loops=1)

4. 0.021 0.284 ↑ 1.0 1 1

Hash Right Join (cost=15.41..16.81 rows=1 width=2,192) (actual time=0.282..0.284 rows=1 loops=1)

  • Hash Cond: (jparouterd8_.device_id = this_.id)
5. 0.009 0.009 ↑ 1.0 28 1

Seq Scan on router_data jparouterd8_ (cost=0.00..1.28 rows=28 width=59) (actual time=0.002..0.009 rows=28 loops=1)

6. 0.006 0.254 ↑ 1.0 1 1

Hash (cost=15.40..15.40 rows=1 width=2,133) (actual time=0.254..0.254 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.047 0.248 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.86..15.40 rows=1 width=2,133) (actual time=0.236..0.248 rows=1 loops=1)

8. 0.017 0.199 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.59..13.10 rows=1 width=1,801) (actual time=0.187..0.199 rows=1 loops=1)

9. 0.005 0.180 ↑ 1.0 1 1

Nested Loop (cost=3.44..10.92 rows=1 width=1,716) (actual time=0.168..0.180 rows=1 loops=1)

10. 0.004 0.172 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.30..8.71 rows=1 width=1,610) (actual time=0.161..0.172 rows=1 loops=1)

11. 0.006 0.165 ↑ 1.0 1 1

Nested Loop (cost=3.02..8.41 rows=1 width=1,606) (actual time=0.154..0.165 rows=1 loops=1)

12. 0.029 0.153 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.74..6.11 rows=1 width=830) (actual time=0.143..0.153 rows=1 loops=1)

13. 0.017 0.118 ↑ 1.0 1 1

Hash Join (cost=2.45..3.80 rows=1 width=822) (actual time=0.108..0.118 rows=1 loops=1)

  • Hash Cond: (jpadevicet4_.id = this_.device_type_id)
14. 0.024 0.024 ↑ 1.0 25 1

Seq Scan on device_types jpadevicet4_ (cost=0.00..1.25 rows=25 width=228) (actual time=0.017..0.024 rows=25 loops=1)

15. 0.042 0.077 ↑ 1.0 1 1

Hash (cost=2.44..2.44 rows=1 width=594) (actual time=0.077..0.077 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.035 0.035 ↑ 1.0 1 1

Index Scan using device_esn_idx on device this_ (cost=0.42..2.44 rows=1 width=594) (actual time=0.033..0.035 rows=1 loops=1)

  • Index Cond: ((esn)::text = '1013066255'::text)
  • Filter: ((status)::text <> 'Deleted'::text)
17. 0.006 0.006 ↓ 0.0 0 1

Index Scan using asset_device_unique_key on asset_device this_1_ (cost=0.29..2.31 rows=1 width=16) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: (this_.id = device_id)
18. 0.006 0.006 ↑ 1.0 1 1

Index Scan using account_id_idx on account jpaaccount2_ (cost=0.28..2.30 rows=1 width=776) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (id = this_.account_id)
19. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using account_subscription_pkey on account_subscription jpaaccount2_1_ (cost=0.27..0.29 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (account_id = jpaaccount2_.id)
  • Heap Fetches: 0
20. 0.003 0.003 ↑ 1.0 1 1

Index Scan using pk_device_configuration on device_configuration jpadevicec3_ (cost=0.14..2.16 rows=1 width=106) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (id = this_.device_configuration_id)
21. 0.002 0.002 ↓ 0.0 0 1

Index Scan using io_profiles_id_idx on io_profiles jpaioprofi5_ (cost=0.15..2.17 rows=1 width=85) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (this_.io_profile_id = id)
22. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_peg_behavior on peg_behavior jpapegbeha6_ (cost=0.28..2.29 rows=1 width=332) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (this_.peg_behavior_id = id)
23. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_device on device jpadevice7_ (cost=0.29..2.31 rows=1 width=594) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (this_.swapped_device_id = id)
24. 0.002 0.002 ↓ 0.0 0 1

Index Scan using asset_device_unique_key on asset_device jpadevice7_1_ (cost=0.29..0.31 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (jpadevice7_.id = device_id)
25. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_asset on asset jpaasset9_ (cost=0.29..0.34 rows=1 width=342) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (this_1_.asset_id = id)