explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wcix : Optimization for: plan #xjQ9

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.150 2.351 ↓ 5.0 372 1

Sort (cost=1,051.70..1,051.88 rows=74 width=100) (actual time=2.232..2.351 rows=372 loops=1)

  • Sort Key: uc.type DESC, ((uc.nr + uc.addr_offset))
  • Sort Method: quicksort Memory: 85kB
2. 0.434 1.201 ↓ 5.0 372 1

Nested Loop (cost=0.84..1,049.40 rows=74 width=100) (actual time=0.058..1.201 rows=372 loops=1)

3. 0.182 0.182 ↓ 1.6 65 1

Index Scan using ix_devices_connection on devices d (cost=0.42..341.76 rows=41 width=6) (actual time=0.018..0.182 rows=65 loops=1)

  • Index Cond: (connection_device_id = 53,826)
  • Filter: (activation_status < 9999)
  • Rows Removed by Filter: 6
4. 0.585 0.585 ↓ 1.5 6 65

Index Scan using ix_upload_conf_device_update_cl on upload_configuration uc (cost=0.42..17.21 rows=4 width=98) (actual time=0.005..0.009 rows=6 loops=65)

  • Index Cond: ((device_id = d.id) AND (update_class = 1))
  • Filter: is_pushed
Planning time : 0.491 ms
Execution time : 2.655 ms