#	exclusive	inclusive	rows x	rows	loops	node
1.	0.001	81.359	↑ 1.0	5	1	→ Limit (cost=1984.47..1984.48 rows=5 width=113) (actual time=81.358..81.359 rows=5 loops=1)
2.	38.594	81.358	↑ 5737.2	5	1	→ Sort (cost=1984.47..2056.18 rows=28686 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	28686	1	→ Group (cost=0.00..1508.00 rows=28686 width=113) (actual time=1.075..42.764 rows=28686 loops=1)
4.	30.371	30.371	↑ 1.0	28686	1	→ Index Scan using auth_user_pkey on auth_user (cost=0.00..1436.29 rows=28686 width=113) (actual time=1.072..30.371 rows=28686 loops=1)

                                                                        QUERY PLAN                                                                        
----------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=1984.47..1984.48 rows=5 width=113) (actual time=81.358..81.359 rows=5 loops=1)
   ->  Sort  (cost=1984.47..2056.18 rows=28686 width=113) (actual time=81.357..81.358 rows=5 loops=1)
         Sort Key: username
         Sort Method: top-N heapsort  Memory: 26kB
         ->  Group  (cost=0.00..1508.00 rows=28686 width=113) (actual time=1.075..42.764 rows=28686 loops=1)
               ->  Index Scan using auth_user_pkey on auth_user  (cost=0.00..1436.29 rows=28686 width=113) (actual time=1.072..30.371 rows=28686 loops=1)

Per node type stats

node type	count	sum of times	% of query
Group	1	12.393 ms	15.2 %
Index Scan	1	30.371 ms	37.3 %
Limit	1	0.001 ms	0.0 %
Sort	1	38.594 ms	47.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
auth_user	1	30.371 ms	37.3 %
Index Scan	1	30.371 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 5QW

Colorize:

Columns visibility:

Per node type stats

Per table stats