explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nlvS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Subquery Scan on rank_filter (cost=10,051,037.25..11,211,585.06 rows=165,793 width=58) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=10,051,037.25..10,797,103.70 rows=33,158,509 width=66) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=10,051,037.25..10,133,933.52 rows=33,158,509 width=50) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using iot_data_nov_install_ts_37ad54a7 on iot_data_nov (cost=0.57..2,509,015.69 rows=33,158,509 width=50) (actual rows= loops=)