explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RRfq

Settings
# exclusive inclusive rows x rows loops node
1. 56.730 55,464.025 ↑ 1.0 1 1

Aggregate (cost=864,050.99..864,051.00 rows=1 width=8) (actual time=55,464.025..55,464.025 rows=1 loops=1)

2. 55,407.295 55,407.295 ↓ 1.7 415,648 1

Index Only Scan using sensor_data_idx_gateway_mac on sensor_data (cost=0.57..863,441.69 rows=243,719 width=0) (actual time=28.155..55,407.295 rows=415,648 loops=1)

  • Index Cond: (gateway_mac = '111:111:111'::text)
  • Heap Fetches: 415648
Planning time : 0.166 ms
Execution time : 55,464.101 ms