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. 0.000 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. 7,510.260 501,606.183 ↑ 87,764.5 17 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. 16,573.572 494,095.923 ↑ 1.3 1,171,966 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. 1,864.209 477,409.866 ↑ 1.3 1,171,966 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. 77,019.912 475,349.445 ↑ 1.3 1,171,966 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. 14,518.125 383,407.380 ↑ 1.3 1,171,966 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. 1,474.047 368,770.251 ↑ 1.3 1,171,966 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. 8,895.372 367,141.299 ↑ 1.3 1,171,966 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. 21,197.094 358,133.925 ↑ 1.3 1,171,966 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. 2,169.834 331,243.572 ↑ 1.3 1,171,966 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. 328,855.089 328,855.089 ↑ 1.3 1,171,966 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: 17444144
13. 93.816 218.649 ↑ 1.2 74,505 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: 262144 Batches: 1 Memory Usage: 10816kB
14. 124.833 124.833 ↑ 1.2 74,505 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. 3,107.175 5,693.259 ↑ 1.3 2,928,522 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: 131072 Batches: 128 Memory Usage: 3776kB
16. 2,586.084 2,586.084 ↑ 1.3 2,928,522 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. 79.824 112.002 ↑ 1.8 20,773 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: 16384 Batches: 8 Memory Usage: 2400kB
18. 32.178 32.178 ↑ 1.8 20,773 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. 70.623 154.905 ↑ 1.2 74,505 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: 262144 Batches: 1 Memory Usage: 10848kB
20. 84.282 84.282 ↑ 1.2 74,505 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. 88.818 119.004 ↑ 1.8 20,773 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: 16384 Batches: 8 Memory Usage: 2400kB
22. 30.186 30.186 ↑ 1.8 20,773 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. 9,918.099 14,922.153 ↑ 1.2 1,718,065 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: 16384 Batches: 512 Memory Usage: 3904kB
24. 5,004.054 5,004.054 ↑ 1.2 1,718,065 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. 88.020 196.212 ↑ 1.2 74,505 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: 262144 Batches: 1 Memory Usage: 10848kB
26. 108.192 108.192 ↑ 1.2 74,505 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. 79.233 112.485 ↑ 1.8 20,773 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: 16384 Batches: 8 Memory Usage: 2400kB
28. 33.252 33.252 ↑ 1.8 20,773 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