explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M3Ew : Sort spuer individuals by amount

Settings
# exclusive inclusive rows x rows loops node
1. 0.268 21,194.827 ↑ 1.0 25 1

Limit (cost=1,391,543.94..1,391,546.86 rows=25 width=352) (actual time=20,219.635..21,194.827 rows=25 loops=1)

2. 978.579 21,194.559 ↑ 376,369.0 25 1

Gather Merge (cost=1,391,543.94..2,489,363.39 rows=9,409,224 width=352) (actual time=20,219.633..21,194.559 rows=25 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 3,742.261 20,215.980 ↑ 235,230.6 20 3 / 3

Sort (cost=1,390,543.92..1,402,305.45 rows=4,704,612 width=352) (actual time=20,215.977..20,215.980 rows=20 loops=3)

  • Sort Key: mv_super_individual_donation_summaries.total_donations
  • Sort Method: top-N heapsort Memory: 46kB
  • Worker 0: Sort Method: top-N heapsort Memory: 45kB
  • Worker 1: Sort Method: top-N heapsort Memory: 46kB
4. 11,613.490 16,473.719 ↑ 1.2 3,763,727 3 / 3

Parallel Hash Join (cost=189,859.77..1,257,783.15 rows=4,704,612 width=352) (actual time=12,143.144..16,473.719 rows=3,763,727 loops=3)

  • Hash Cond: (super_individuals.id = mv_super_individual_donation_summaries.super_individual_id)
5. 2,988.918 2,988.918 ↑ 1.3 3,918,535 3 / 3

Parallel Seq Scan on super_individuals (cost=0.00..592,023.69 rows=4,898,169 width=344) (actual time=0.045..2,988.918 rows=3,918,535 loops=3)

6. 1,074.931 1,871.311 ↑ 1.2 3,763,727 3 / 3

Parallel Hash (cost=108,080.12..108,080.12 rows=4,704,612 width=12) (actual time=1,871.310..1,871.311 rows=3,763,727 loops=3)

  • Buckets: 131072 Batches: 256 Memory Usage: 3136kB
7. 796.380 796.380 ↑ 1.2 3,763,727 3 / 3

Parallel Seq Scan on mv_super_individual_donation_summaries (cost=0.00..108,080.12 rows=4,704,612 width=12) (actual time=0.008..796.380 rows=3,763,727 loops=3)

Planning time : 0.282 ms
Execution time : 21,194.972 ms