explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8GC4

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

Nested Loop Left Join (cost=4.73..18.36 rows=1 width=3,077) (actual time=0.113..0.126 rows=1 loops=1)

2. 0.006 0.117 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.44..18.02 rows=1 width=2,735) (actual time=0.105..0.117 rows=1 loops=1)

3. 0.007 0.110 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.15..17.71 rows=1 width=2,727) (actual time=0.098..0.110 rows=1 loops=1)

4. 0.004 0.102 ↑ 1.0 1 1

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

5. 0.004 0.096 ↑ 1.0 1 1

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

6. 0.005 0.090 ↑ 1.0 1 1

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

7. 0.005 0.082 ↑ 1.0 1 1

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

8. 0.004 0.074 ↑ 1.0 1 1

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

9. 0.004 0.065 ↑ 1.0 1 1

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

10. 0.017 0.056 ↑ 1.0 1 1

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

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

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

12. 0.004 0.027 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.023 0.023 ↑ 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.022..0.023 rows=1 loops=1)

  • Index Cond: ((esn)::text = '1013066255'::text)
  • Filter: ((status)::text <> 'Deleted'::text)
14. 0.005 0.005 ↓ 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.005 rows=0 loops=1)

  • Index Cond: (this_.id = device_id)
15. 0.005 0.005 ↑ 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.005 rows=1 loops=1)

  • Index Cond: (id = this_.account_id)
16. 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
17. 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)
18. 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.001..0.002 rows=0 loops=1)

  • Index Cond: (this_.io_profile_id = id)
19. 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.001..0.002 rows=0 loops=1)

  • Index Cond: (this_.peg_behavior_id = id)
20. 0.001 0.001 ↓ 0.0 0 1

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

  • Index Cond: (this_.swapped_device_id = id)
21. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Index Cond: (jpadevice7_.id = device_id)
22. 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)