explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PdHS

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.164 ↓ 4.0 4 1

Nested Loop Left Join (cost=3.07..19.74 rows=1 width=1,654) (actual time=0.063..0.164 rows=4 loops=1)

2. 0.000 0.149 ↓ 4.0 4 1

Nested Loop Left Join (cost=2.94..19.57 rows=1 width=1,597) (actual time=0.058..0.149 rows=4 loops=1)

3. 0.009 0.145 ↓ 4.0 4 1

Nested Loop Left Join (cost=2.66..19.26 rows=1 width=1,589) (actual time=0.057..0.145 rows=4 loops=1)

4. 0.005 0.136 ↓ 4.0 4 1

Nested Loop Left Join (cost=2.37..18.71 rows=1 width=1,315) (actual time=0.054..0.136 rows=4 loops=1)

5. 0.008 0.127 ↓ 4.0 4 1

Nested Loop Left Join (cost=2.09..18.40 rows=1 width=1,005) (actual time=0.049..0.127 rows=4 loops=1)

6. 0.005 0.119 ↓ 4.0 4 1

Nested Loop (cost=1.95..18.23 rows=1 width=925) (actual time=0.047..0.119 rows=4 loops=1)

7. 0.009 0.106 ↓ 4.0 4 1

Nested Loop (cost=1.67..17.88 rows=1 width=691) (actual time=0.043..0.106 rows=4 loops=1)

8. 0.004 0.089 ↓ 4.0 4 1

Nested Loop Left Join (cost=1.40..17.58 rows=1 width=605) (actual time=0.037..0.089 rows=4 loops=1)

9. 0.009 0.073 ↓ 4.0 4 1

Nested Loop Left Join (cost=1.13..17.27 rows=1 width=601) (actual time=0.030..0.073 rows=4 loops=1)

10. 0.005 0.056 ↓ 4.0 4 1

Nested Loop Left Join (cost=0.84..16.92 rows=1 width=298) (actual time=0.025..0.056 rows=4 loops=1)

11. 0.007 0.043 ↓ 4.0 4 1

Nested Loop (cost=0.56..16.61 rows=1 width=290) (actual time=0.022..0.043 rows=4 loops=1)

12. 0.016 0.016 ↓ 4.0 4 1

Index Only Scan using asset_device_pkey on asset_device devices0_ (cost=0.28..8.29 rows=1 width=16) (actual time=0.012..0.016 rows=4 loops=1)

  • Index Cond: (asset_id = 33,624)
  • Heap Fetches: 4
13. 0.020 0.020 ↑ 1.0 1 4

Index Scan using pk_device on device jpadevice1_ (cost=0.29..8.30 rows=1 width=274) (actual time=0.005..0.005 rows=1 loops=4)

  • Index Cond: (id = devices0_.device_id)
14. 0.008 0.008 ↑ 1.0 1 4

Index Scan using asset_device_unique_key on asset_device jpadevice1_1_ (cost=0.28..0.30 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (jpadevice1_.id = device_id)
15. 0.008 0.008 ↑ 1.0 1 4

Index Scan using account_id_idx on account jpaaccount2_ (cost=0.29..0.35 rows=1 width=303) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (jpadevice1_.account_id = id)
16. 0.012 0.012 ↑ 1.0 1 4

Index Only Scan using account_subscription_pkey on account_subscription jpaaccount2_1_ (cost=0.28..0.30 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=4)

  • Index Cond: (account_id = jpaaccount2_.id)
  • Heap Fetches: 4
17. 0.008 0.008 ↑ 1.0 1 4

Index Scan using pk_device_configuration on device_configuration jpadevicec3_ (cost=0.27..0.29 rows=1 width=86) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (id = jpadevice1_.device_configuration_id)
18. 0.008 0.008 ↑ 1.0 1 4

Index Scan using pk_device_types on device_types jpadevicet4_ (cost=0.28..0.33 rows=1 width=234) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (id = jpadevice1_.device_type_id)
19. 0.000 0.000 ↓ 0.0 0 4

Index Scan using io_profiles_id_idx on io_profiles jpaioprofi5_ (cost=0.14..0.16 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (jpadevice1_.io_profile_id = id)
20. 0.004 0.004 ↓ 0.0 0 4

Index Scan using pk_peg_behavior on peg_behavior jpapegbeha6_ (cost=0.28..0.31 rows=1 width=310) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (jpadevice1_.peg_behavior_id = id)
21. 0.000 0.000 ↓ 0.0 0 4

Index Scan using pk_device on device jpadevice7_ (cost=0.29..0.54 rows=1 width=274) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (jpadevice1_.swapped_device_id = id)
22. 0.004 0.004 ↓ 0.0 0 4

Index Scan using asset_device_unique_key on asset_device jpadevice7_1_ (cost=0.28..0.30 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (jpadevice7_.id = device_id)
23. 0.008 0.008 ↑ 1.0 1 4

Index Scan using router_data_device_id_unique_idx on router_data jparouterd8_ (cost=0.14..0.16 rows=1 width=57) (actual time=0.001..0.002 rows=1 loops=4)

  • Index Cond: (jpadevice1_.id = device_id)
Planning time : 3.592 ms
Execution time : 0.659 ms