#	exclusive	inclusive	rows x	rows	loops	node
1.	29.322	403.084	↑ 44.3	134	1	→ GroupAggregate (cost=600.75..823.39 rows=5937 width=225) (actual time=359.228..403.084 rows=134 loops=1)
2.	314.105	373.762	↓ 1.3	7944	1	→ Sort (cost=600.75..615.60 rows=5937 width=225) (actual time=358.974..373.762 rows=7944 loops=1) Sort Key: todolists.date_added, todolists.id, todolists.creator_id, todolists.name, todolists.description, auth_user.id, auth_user.username, auth_user.first_name, auth_use Sort Method: quicksort Memory: 3109kB
3.	41.460	59.657	↓ 1.3	7944	1	→ Hash Right Join (cost=13.18..228.64 rows=5937 width=225) (actual time=2.256..59.657 rows=7944 loops=1) Hash Cond: (todolist_pkgs.list_id = todolists.id)
4.	15.977	15.977	↑ 1.0	7941	1	→ Seq Scan on todolist_pkgs (cost=0.00..125.79 rows=8079 width=8) (actual time=0.018..15.977 rows=7941 loops=1)
5.	0.542	2.220	↓ 1.4	134	1	→ Hash (cost=11.97..11.97 rows=97 width=221) (actual time=2.220..2.220 rows=134 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 34kB
6.	0.742	1.678	↓ 1.4	134	1	→ Hash Join (cost=5.18..11.97 rows=97 width=221) (actual time=0.653..1.678 rows=134 loops=1) Hash Cond: (todolists.creator_id = auth_user.id)
7.	0.349	0.349	↓ 1.0	134	1	→ Seq Scan on todolists (cost=0.00..5.32 rows=132 width=195) (actual time=0.020..0.349 rows=134 loops=1)
8.	0.301	0.587	↑ 1.0	97	1	→ Hash (cost=3.97..3.97 rows=97 width=26) (actual time=0.587..0.587 rows=97 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 6kB
9.	0.286	0.286	↑ 1.0	97	1	→ Seq Scan on auth_user (cost=0.00..3.97 rows=97 width=26) (actual time=0.032..0.286 rows=97 loops=1)

 GroupAggregate  (cost=600.75..823.39 rows=5937 width=225) (actual time=359.228..403.084 rows=134 loops=1)
   ->  Sort  (cost=600.75..615.60 rows=5937 width=225) (actual time=358.974..373.762 rows=7944 loops=1)
         Sort Key: todolists.date_added, todolists.id, todolists.creator_id, todolists.name, todolists.description, auth_user.id, auth_user.username, auth_user.first_name, auth_use
r.last_name
         Sort Method: quicksort  Memory: 3109kB
         ->  Hash Right Join  (cost=13.18..228.64 rows=5937 width=225) (actual time=2.256..59.657 rows=7944 loops=1)
               Hash Cond: (todolist_pkgs.list_id = todolists.id)
               ->  Seq Scan on todolist_pkgs  (cost=0.00..125.79 rows=8079 width=8) (actual time=0.018..15.977 rows=7941 loops=1)
               ->  Hash  (cost=11.97..11.97 rows=97 width=221) (actual time=2.220..2.220 rows=134 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 34kB
                     ->  Hash Join  (cost=5.18..11.97 rows=97 width=221) (actual time=0.653..1.678 rows=134 loops=1)
                           Hash Cond: (todolists.creator_id = auth_user.id)
                           ->  Seq Scan on todolists  (cost=0.00..5.32 rows=132 width=195) (actual time=0.020..0.349 rows=134 loops=1)
                           ->  Hash  (cost=3.97..3.97 rows=97 width=26) (actual time=0.587..0.587 rows=97 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 6kB
                                 ->  Seq Scan on auth_user  (cost=0.00..3.97 rows=97 width=26) (actual time=0.032..0.286 rows=97 loops=1)
 Total runtime: 405.766 ms

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	29.322 ms	7.3 %
Hash	2	0.843 ms	0.2 %
Hash Join	1	0.742 ms	0.2 %
Hash Right Join	1	41.460 ms	10.3 %
Seq Scan	3	16.612 ms	4.1 %
Sort	1	314.105 ms	77.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
auth_user	1	0.286 ms	0.1 %
Seq Scan	1	0.286 ms	100.0 %
todolist_pkgs	1	15.977 ms	4.0 %
Seq Scan	1	15.977 ms	100.0 %
todolists	1	0.349 ms	0.1 %
Seq Scan	1	0.349 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: bTS

Colorize:

Columns visibility:

Per node type stats

Per table stats