explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1GxD

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 560,552.065 ↑ 1.0 100 1

Limit (cost=0.56..13.29 rows=100 width=894) (actual time=560,551.045..560,552.065 rows=100 loops=1)

2. 77,269.024 560,552.023 ↑ 229,556.6 100 1

WindowAgg (cost=0.56..2,921,485.21 rows=22,955,660 width=894) (actual time=560,551.042..560,552.023 rows=100 loops=1)

3. 483,282.999 483,282.999 ↓ 1.0 22,959,055 1

Index Scan Backward using person_8310db0d_2715_4574_a354_5f69d1f17ac6_last_seen_idx on person_8310db0d_2715_4574_a354_5f69d1f17ac6 p (cost=0.56..2,634,539.46 rows=22,955,660 width=886) (actual time=0.021..483,282.999 rows=22,959,055 loops=1)

Planning time : 1.202 ms
Execution time : 564,957.065 ms