explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 5QW

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.001 81.359 ↑ 1.0 5 1

Limit (cost=1,984.47..1,984.48 rows=5 width=113) (actual time=81.358..81.359 rows=5 loops=1)

2. 38.594 81.358 ↑ 5,737.2 5 1

Sort (cost=1,984.47..2,056.18 rows=28,686 width=113) (actual time=81.357..81.358 rows=5 loops=1)

  • Sort Key: username
  • Sort Method: top-N heapsort Memory: 26kB
3. 12.393 42.764 ↑ 1.0 28,686 1

Group (cost=0.00..1,508.00 rows=28,686 width=113) (actual time=1.075..42.764 rows=28,686 loops=1)

4. 30.371 30.371 ↑ 1.0 28,686 1

Index Scan using auth_user_pkey on auth_user (cost=0.00..1,436.29 rows=28,686 width=113) (actual time=1.072..30.371 rows=28,686 loops=1)