explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wXeZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 50.714 ↑ 25.0 1 1

Limit (cost=73,282.11..73,282.18 rows=25 width=1,473) (actual time=50.713..50.714 rows=1 loops=1)

2. 0.016 50.711 ↑ 2,546.0 1 1

Sort (cost=73,282.11..73,288.48 rows=2,546 width=1,473) (actual time=50.711..50.711 rows=1 loops=1)

  • Sort Key: receipts.contribution_amount
  • Sort Method: quicksort Memory: 26kB
3. 7.730 50.695 ↑ 2,546.0 1 1

Hash Right Join (cost=69,584.26..73,210.27 rows=2,546 width=1,473) (actual time=50.688..50.695 rows=1 loops=1)

  • Hash Cond: (super_committees_2.id = committees_3.super_committee_id)
4. 9.975 9.975 ↓ 1.0 62,320 1

Seq Scan on super_committees super_committees_2 (cost=0.00..2,900.75 rows=62,275 width=272) (actual time=0.008..9.975 rows=62,320 loops=1)

5. 0.011 32.990 ↑ 2,546.0 1 1

Hash (cost=69,552.44..69,552.44 rows=2,546 width=1,205) (actual time=32.990..32.990 rows=1 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 33kB
6. 7.344 32.979 ↑ 2,546.0 1 1

Hash Right Join (cost=65,926.43..69,552.44 rows=2,546 width=1,205) (actual time=32.972..32.979 rows=1 loops=1)

  • Hash Cond: (super_committees_3.id = committees_2.super_committee_id)
7. 9.995 9.995 ↓ 1.0 62,320 1

Seq Scan on super_committees super_committees_3 (cost=0.00..2,900.75 rows=62,275 width=272) (actual time=0.006..9.995 rows=62,320 loops=1)

8. 0.000 15.640 ↑ 2,546.0 1 1

Hash (cost=65,894.61..65,894.61 rows=2,546 width=937) (actual time=15.640..15.640 rows=1 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 33kB
9. 4.111 15.839 ↑ 2,546.0 1 1

Gather (cost=21,220.67..65,894.61 rows=2,546 width=937) (actual time=9.500..15.839 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
10. 0.005 11.728 ↓ 0.0 0 2

Nested Loop Left Join (cost=20,220.67..64,640.01 rows=1,498 width=937) (actual time=8.736..11.728 rows=0 loops=2)

11. 0.000 11.721 ↓ 0.0 0 2

Nested Loop Left Join (cost=20,220.25..54,518.88 rows=1,498 width=933) (actual time=8.730..11.721 rows=0 loops=2)

12. 0.000 10.954 ↓ 0.0 0 2

Nested Loop Left Join (cost=20,219.82..45,694.20 rows=1,498 width=601) (actual time=7.963..10.954 rows=0 loops=2)

13. 0.001 10.349 ↓ 0.0 0 2

Nested Loop Left Join (cost=20,219.39..33,267.71 rows=1,498 width=597) (actual time=7.358..10.349 rows=0 loops=2)

14. 3.956 10.345 ↓ 0.0 0 2

Parallel Hash Join (cost=20,218.97..23,146.57 rows=1,498 width=593) (actual time=7.353..10.345 rows=0 loops=2)

  • Hash Cond: (super_committees_1.id = committees_1.super_committee_id)
15. 4.695 4.695 ↑ 1.2 31,160 2

Parallel Seq Scan on super_committees super_committees_1 (cost=0.00..2,644.32 rows=36,632 width=272) (actual time=0.003..4.695 rows=31,160 loops=2)

16. 0.000 1.694 ↓ 0.0 0 2

Parallel Hash (cost=20,200.24..20,200.24 rows=1,498 width=325) (actual time=1.693..1.694 rows=0 loops=2)

  • Buckets: 4096 Batches: 1 Memory Usage: 64kB
17. 0.011 3.362 ↑ 1,498.0 1 1

Nested Loop (cost=97.79..20,200.24 rows=1,498 width=325) (actual time=3.360..3.362 rows=1 loops=1)

18. 0.467 0.506 ↑ 1,498.0 1 1

Parallel Bitmap Heap Scan on receipts (cost=97.37..10,079.11 rows=1,498 width=321) (actual time=0.505..0.506 rows=1 loops=1)

  • Recheck Cond: (recipient_committee_id = ANY ('{66686,66685,66684,66683,66682,66681,66680,66679,66678,66677,66676,66675,66674,66673,66672,66671,66670}'::integer[]))
  • Heap Blocks: exact=1
19. 0.039 0.039 ↑ 2,546.0 1 1

Bitmap Index Scan on ix_receipts_recipient_committee_id (cost=0.00..96.73 rows=2,546 width=0) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: (recipient_committee_id = ANY ('{66686,66685,66684,66683,66682,66681,66680,66679,66678,66677,66676,66675,66674,66673,66672,66671,66670}'::integer[]))
20. 2.845 2.845 ↑ 1.0 1 1

Index Scan using committees_pkey on committees committees_1 (cost=0.42..6.76 rows=1 width=8) (actual time=2.845..2.845 rows=1 loops=1)

  • Index Cond: (id = receipts.recipient_committee_id)
21. 0.003 0.003 ↓ 0.0 0 1

Index Scan using committees_pkey on committees committees_2 (cost=0.42..6.76 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (receipts.donor_committee_id = id)
22. 1.202 1.202 ↑ 1.0 1 1

Index Scan using ix_individual_matches_individual_id on individual_matches (cost=0.43..8.30 rows=1 width=8) (actual time=1.202..1.202 rows=1 loops=1)

  • Index Cond: (receipts.donor_individual_id = individual_id)
23. 1.527 1.527 ↑ 1.0 1 1

Index Scan using super_individuals_pkey on super_individuals (cost=0.43..5.89 rows=1 width=336) (actual time=1.527..1.527 rows=1 loops=1)

  • Index Cond: (individual_matches.super_individual_id = id)
24. 0.002 0.002 ↓ 0.0 0 1

Index Scan using committees_pkey on committees committees_3 (cost=0.42..6.76 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (receipts.conduit_committee_id = id)
Planning time : 37.907 ms
Execution time : 51.265 ms