explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YVP

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 16.166 3,282.245 ↓ 156.8 31,351 1

HashAggregate (cost=993,409.91..993,412.91 rows=200 width=32) (actual time=3,276.080..3,282.245 rows=31,351 loops=1)

2. 77.641 3,266.079 ↑ 986.7 31,351 1

Merge Join (cost=297,220.97..916,075.75 rows=30,933,664 width=32) (actual time=3,111.085..3,266.079 rows=31,351 loops=1)

  • Merge Cond: ((workareas.aspect)::integer = (grouprights.aspect)::integer)
3. 30.699 140.459 ↓ 1.4 50,809 1

Sort (cost=9,373.31..9,463.86 rows=36,220 width=36) (actual time=137.391..140.459 rows=50,809 loops=1)

  • Sort Key: workareas.aspect
  • Sort Method: quicksort Memory: 8094kB
4. 63.882 109.760 ↓ 1.4 50,823 1

Hash Anti Join (cost=3,863.07..6,630.64 rows=36,220 width=36) (actual time=36.458..109.760 rows=50,823 loops=1)

  • Hash Cond: ((workareas.aspect)::integer = (aspectinactive.id)::integer)
5. 9.461 9.461 ↑ 1.0 72,440 1

Seq Scan on workareas (cost=0.00..1,916.40 rows=72,440 width=36) (actual time=0.007..9.461 rows=72,440 loops=1)

6. 23.468 36.417 ↑ 1.0 138,403 1

Hash (cost=2,133.03..2,133.03 rows=138,403 width=4) (actual time=36.417..36.417 rows=138,403 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 5948kB
7. 12.949 12.949 ↑ 1.0 138,403 1

Seq Scan on aspectinactive (cost=0.00..2,133.03 rows=138,403 width=4) (actual time=0.006..12.949 rows=138,403 loops=1)

8. 1,071.361 3,047.979 ↓ 4.7 800,592 1

Sort (cost=287,847.66..288,274.69 rows=170,810 width=4) (actual time=2,949.319..3,047.979 rows=800,592 loops=1)

  • Sort Key: grouprights.aspect
  • Sort Method: external sort Disk: 14096kB
9. 416.249 1,976.618 ↓ 4.7 800,592 1

Hash Join (cost=10,005.97..273,002.54 rows=170,810 width=4) (actual time=1,337.832..1,976.618 rows=800,592 loops=1)

  • Hash Cond: ((grouprights."group")::integer = (groups.id)::integer)
10. 1,504.766 1,504.766 ↑ 1.6 3,867,485 1

Seq Scan on grouprights (cost=0.00..206,182.80 rows=6,297,790 width=8) (actual time=0.034..1,504.766 rows=3,867,485 loops=1)

  • Filter: visit
11. 0.004 55.603 ↑ 2,476.5 2 1

Hash (cost=9,944.06..9,944.06 rows=4,953 width=8) (actual time=55.603..55.603 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
12. 0.075 55.599 ↑ 2,476.5 2 1

Hash Join (cost=5,191.65..9,944.06 rows=4,953 width=8) (actual time=55.593..55.599 rows=2 loops=1)

  • Hash Cond: ((u2g."group")::integer = (groups.id)::integer)
13. 0.010 0.028 ↑ 2,476.5 2 1

Bitmap Heap Scan on user2group u2g (cost=94.74..4,748.10 rows=4,953 width=4) (actual time=0.023..0.028 rows=2 loops=1)

  • Recheck Cond: (("user")::integer = 234393)
14. 0.018 0.018 ↑ 2,476.5 2 1

Bitmap Index Scan on "fki_user2group_FK1" (cost=0.00..93.51 rows=4,953 width=0) (actual time=0.018..0.018 rows=2 loops=1)

  • Index Cond: (("user")::integer = 234393)
15. 33.191 55.496 ↑ 1.0 182,618 1

Hash (cost=2,814.18..2,814.18 rows=182,618 width=4) (actual time=55.496..55.496 rows=182,618 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 6421kB
16. 22.305 22.305 ↑ 1.0 182,618 1

Seq Scan on groups (cost=0.00..2,814.18 rows=182,618 width=4) (actual time=0.007..22.305 rows=182,618 loops=1)