explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uv25

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 197.248 ↑ 1.0 10 1

Limit (cost=8,460.65..8,461.82 rows=10 width=84) (actual time=194.553..197.248 rows=10 loops=1)

2. 0.000 197.244 ↑ 4,749.2 10 1

Gather Merge (cost=8,460.65..14,001.77 rows=47,492 width=84) (actual time=194.552..197.244 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 107.844 520.308 ↑ 3,392.3 7 3

Sort (cost=7,460.63..7,519.99 rows=23,746 width=84) (actual time=173.435..173.436 rows=7 loops=3)

  • Sort Key: tr.transaktionsdatum DESC
  • Sort Method: top-N heapsort Memory: 26kB
  • Worker 0: Sort Method: top-N heapsort Memory: 26kB
  • Worker 1: Sort Method: top-N heapsort Memory: 26kB
4. 233.529 412.464 ↓ 2.7 63,866 3

Hash Join (cost=168.56..6,947.48 rows=23,746 width=84) (actual time=14.956..137.488 rows=63,866 loops=3)

  • Hash Cond: (tr.produktid = bestandsdaten.produktid)
5. 158.640 158.640 ↓ 1.4 488 3

Parallel Seq Scan on transaktionsdaten tr (cost=0.00..6,369.78 rows=349 width=87) (actual time=7.852..52.880 rows=488 loops=3)

  • Filter: (kundenid = '4011710465'::text)
  • Rows Removed by Filter: 93186
6. 10.632 20.295 ↓ 1.4 4,000 3

Hash (cost=131.58..131.58 rows=2,958 width=37) (actual time=6.764..6.765 rows=4,000 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 308kB
7. 9.663 9.663 ↓ 1.4 4,000 3

Seq Scan on bestandsdaten (cost=0.00..131.58 rows=2,958 width=37) (actual time=0.098..3.221 rows=4,000 loops=3)