explain.depesz.com

A tool for finding a real cause for slow queries.

Result: bTS

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)