explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FVIK

Settings
# exclusive inclusive rows x rows loops node
1. 0.348 168,387.246 ↑ 1.0 25 1

Limit (cost=5,102,837.74..5,102,840.66 rows=25 width=1,481) (actual time=167,207.818..168,387.246 rows=25 loops=1)

2. 1,184.837 168,386.898 ↑ 119,359.7 25 1

Gather Merge (cost=5,102,837.74..5,450,994.45 rows=2,983,992 width=1,481) (actual time=167,207.816..168,386.898 rows=25 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,503.420 167,202.061 ↑ 87,764.5 17 3 / 3

Sort (cost=5,101,837.72..5,105,567.71 rows=1,491,996 width=1,481) (actual time=167,202.060..167,202.061 rows=17 loops=3)

  • Sort Key: (round(receipts.contribution_amount))
  • Sort Method: top-N heapsort Memory: 64kB
  • Worker 0: Sort Method: top-N heapsort Memory: 78kB
  • Worker 1: Sort Method: top-N heapsort Memory: 80kB
4. 5,524.524 164,698.641 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Left Join (cost=857,173.52..5,059,734.67 rows=1,491,996 width=1,481) (actual time=162,861.028..164,698.641 rows=1,171,966 loops=3)

  • Hash Cond: (committees_3.super_committee_id = super_committees_2.id)
5. 621.403 159,136.622 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Left Join (cost=852,747.30..4,597,571.71 rows=1,491,996 width=1,205) (actual time=137,100.718..159,136.622 rows=1,171,966 loops=3)

  • Hash Cond: (receipts.conduit_committee_id = committees_3.id)
6. 25,673.304 158,449.815 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Left Join (cost=841,978.75..4,582,886.66 rows=1,491,996 width=1,201) (actual time=137,034.639..158,449.815 rows=1,171,966 loops=3)

  • Hash Cond: (individual_matches.super_individual_id = super_individuals.id)
7. 4,839.375 127,802.460 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Left Join (cost=242,168.54..3,558,587.96 rows=1,491,996 width=869) (actual time=125,866.784..127,802.460 rows=1,171,966 loops=3)

  • Hash Cond: (committees_2.super_committee_id = super_committees_3.id)
8. 491.349 122,923.417 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Left Join (cost=237,742.32..3,318,708.99 rows=1,491,996 width=601) (actual time=121,156.434..122,923.417 rows=1,171,966 loops=3)

  • Hash Cond: (receipts.donor_committee_id = committees_2.id)
9. 2,965.124 122,380.433 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Join (cost=226,973.77..3,304,023.95 rows=1,491,996 width=597) (actual time=121,104.414..122,380.433 rows=1,171,966 loops=3)

  • Hash Cond: (committees_1.super_committee_id = super_committees_1.id)
10. 7,065.698 119,377.975 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Left Join (cost=222,547.55..3,163,222.98 rows=1,491,996 width=329) (actual time=113,945.777..119,377.975 rows=1,171,966 loops=3)

  • Hash Cond: (receipts.donor_individual_id = individual_matches.individual_id)
11. 723.278 110,414.524 ↑ 1.3 1,171,966 3 / 3

Parallel Hash Join (cost=10,768.55..2,805,002.50 rows=1,491,996 width=325) (actual time=16,987.667..110,414.524 rows=1,171,966 loops=3)

  • Hash Cond: (receipts.recipient_committee_id = committees_1.id)
12. 109,618.363 109,618.363 ↑ 1.3 1,171,966 3 / 3

Parallel Seq Scan on receipts (cost=0.00..2,790,317.38 rows=1,491,996 width=321) (actual time=16,914.309..109,618.363 rows=1,171,966 loops=3)

  • Filter: (recipient_committee_id = ANY ('{85496,85495,85494}'::integer[]))
  • Rows Removed by Filter: 17,444,144
13. 31.272 72.883 ↑ 1.2 74,505 3 / 3

Parallel Hash (cost=9,604.91..9,604.91 rows=93,091 width=8) (actual time=72.882..72.883 rows=74,505 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 10,816kB
14. 41.611 41.611 ↑ 1.2 74,505 3 / 3

Parallel Seq Scan on committees committees_1 (cost=0.00..9,604.91 rows=93,091 width=8) (actual time=0.013..41.611 rows=74,505 loops=3)

15. 1,035.725 1,897.753 ↑ 1.3 2,928,522 3 / 3

Parallel Hash (cost=151,700.11..151,700.11 rows=3,661,911 width=8) (actual time=1,897.753..1,897.753 rows=2,928,522 loops=3)

  • Buckets: 131,072 Batches: 128 Memory Usage: 3,776kB
16. 862.028 862.028 ↑ 1.3 2,928,522 3 / 3

Parallel Seq Scan on individual_matches (cost=0.00..151,700.11 rows=3,661,911 width=8) (actual time=0.011..862.028 rows=2,928,522 loops=3)

17. 26.608 37.334 ↑ 1.8 20,773 3 / 3

Parallel Hash (cost=2,644.32..2,644.32 rows=36,632 width=272) (actual time=37.334..37.334 rows=20,773 loops=3)

  • Buckets: 16,384 Batches: 8 Memory Usage: 2,400kB
18. 10.726 10.726 ↑ 1.8 20,773 3 / 3

Parallel Seq Scan on super_committees super_committees_1 (cost=0.00..2,644.32 rows=36,632 width=272) (actual time=0.008..10.726 rows=20,773 loops=3)

19. 23.541 51.635 ↑ 1.2 74,505 3 / 3

Parallel Hash (cost=9,604.91..9,604.91 rows=93,091 width=8) (actual time=51.635..51.635 rows=74,505 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 10,848kB
20. 28.094 28.094 ↑ 1.2 74,505 3 / 3

Parallel Seq Scan on committees committees_2 (cost=0.00..9,604.91 rows=93,091 width=8) (actual time=0.010..28.094 rows=74,505 loops=3)

21. 29.606 39.668 ↑ 1.8 20,773 3 / 3

Parallel Hash (cost=2,644.32..2,644.32 rows=36,632 width=272) (actual time=39.668..39.668 rows=20,773 loops=3)

  • Buckets: 16,384 Batches: 8 Memory Usage: 2,400kB
22. 10.062 10.062 ↑ 1.8 20,773 3 / 3

Parallel Seq Scan on super_committees super_committees_3 (cost=0.00..2,644.32 rows=36,632 width=272) (actual time=0.018..10.062 rows=20,773 loops=3)

23. 3,306.033 4,974.051 ↑ 1.2 1,718,065 3 / 3

Parallel Hash (cost=478,820.76..478,820.76 rows=2,143,476 width=336) (actual time=4,974.050..4,974.051 rows=1,718,065 loops=3)

  • Buckets: 16,384 Batches: 512 Memory Usage: 3,904kB
24. 1,668.018 1,668.018 ↑ 1.2 1,718,065 3 / 3

Parallel Seq Scan on super_individuals (cost=0.00..478,820.76 rows=2,143,476 width=336) (actual time=0.049..1,668.018 rows=1,718,065 loops=3)

25. 29.340 65.404 ↑ 1.2 74,505 3 / 3

Parallel Hash (cost=9,604.91..9,604.91 rows=93,091 width=8) (actual time=65.404..65.404 rows=74,505 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 10,848kB
26. 36.064 36.064 ↑ 1.2 74,505 3 / 3

Parallel Seq Scan on committees committees_3 (cost=0.00..9,604.91 rows=93,091 width=8) (actual time=0.010..36.064 rows=74,505 loops=3)

27. 26.411 37.495 ↑ 1.8 20,773 3 / 3

Parallel Hash (cost=2,644.32..2,644.32 rows=36,632 width=272) (actual time=37.495..37.495 rows=20,773 loops=3)

  • Buckets: 16,384 Batches: 8 Memory Usage: 2,400kB
28. 11.084 11.084 ↑ 1.8 20,773 3 / 3

Parallel Seq Scan on super_committees super_committees_2 (cost=0.00..2,644.32 rows=36,632 width=272) (actual time=0.006..11.084 rows=20,773 loops=3)

Planning time : 6.603 ms
Execution time : 168,387.461 ms