explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Idj5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Join (cost=768,951.87..786,976.12 rows=93,460 width=160) (actual rows= loops=)

  • Merge Cond: (super_individuals.id = super_individuals_3.id)
2. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=141,805.14..159,286.79 rows=1,038 width=124) (actual rows= loops=)

  • Merge Cond: (super_individuals.id = super_individuals_2.id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=70,903.82..88,323.15 rows=2,077 width=124) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=70,903.38..70,939.73 rows=2,077 width=44) (actual rows= loops=)

  • Group Key: super_individuals_1.id
5. 0.000 0.000 ↓ 0.0

Sort (cost=70,903.38..70,908.58 rows=2,077 width=12) (actual rows= loops=)

  • Sort Key: super_individuals_1.id
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,002.16..70,788.94 rows=2,077 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using super_committees_pkey on super_committees super_committees_1 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = 1633)
8. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.87..70,759.86 rows=2,077 width=16) (actual rows= loops=)

  • Workers Planned: 2
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.87..69,552.16 rows=865 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.44..62,645.79 rows=825 width=24) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..59,005.88 rows=825 width=24) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..51,764.37 rows=865 width=16) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on committees committees_1 (cost=0.00..9,837.64 rows=2 width=8) (actual rows= loops=)

  • Filter: (super_committee_id = 1633)
14. 0.000 0.000 ↓ 0.0

Index Scan using ix_receipts_recipient_committee_id on receipts (cost=0.57..20,909.68 rows=5,369 width=16) (actual rows= loops=)

  • Index Cond: (recipient_committee_id = committees_1.id)
15. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (individual_id = receipts.donor_individual_id)
16. 0.000 0.000 ↓ 0.0

Index Only Scan using super_individuals_pkey on super_individuals super_individuals_1 (cost=0.43..4.41 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((id = individual_matches.super_individual_id) AND (id IS NOT NULL))
17. 0.000 0.000 ↓ 0.0

Index Only Scan using individuals_pkey on individuals (cost=0.43..8.37 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = receipts.donor_individual_id)
18. 0.000 0.000 ↓ 0.0

Index Scan using super_individuals_pkey on super_individuals (cost=0.43..8.36 rows=1 width=80) (actual rows= loops=)

  • Index Cond: (id = super_individuals_1.id)
19. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=70,901.32..70,932.48 rows=2,077 width=44) (actual rows= loops=)

  • Group Key: super_individuals_2.id
20. 0.000 0.000 ↓ 0.0

Sort (cost=70,901.32..70,906.51 rows=2,077 width=4) (actual rows= loops=)

  • Sort Key: super_individuals_2.id
21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,002.16..70,786.88 rows=2,077 width=4) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Only Scan using super_committees_pkey on super_committees super_committees_1_1 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = 1828)
23. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.87..70,757.80 rows=2,077 width=8) (actual rows= loops=)

  • Workers Planned: 2
24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.87..69,550.10 rows=865 width=8) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.44..62,643.73 rows=825 width=16) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..59,005.88 rows=825 width=16) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..51,764.37 rows=865 width=8) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on committees committees_1_1 (cost=0.00..9,837.64 rows=2 width=8) (actual rows= loops=)

  • Filter: (super_committee_id = 1828)
29. 0.000 0.000 ↓ 0.0

Index Scan using ix_receipts_recipient_committee_id on receipts receipts_1 (cost=0.57..20,909.68 rows=5,369 width=8) (actual rows= loops=)

  • Index Cond: (recipient_committee_id = committees_1_1.id)
30. 0.000 0.000 ↓ 0.0

Index Scan using ix_individual_matches_individual_id on individual_matches individual_matches_1 (cost=0.43..8.37 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (individual_id = receipts_1.donor_individual_id)
31. 0.000 0.000 ↓ 0.0

Index Only Scan using super_individuals_pkey on super_individuals super_individuals_2 (cost=0.43..4.41 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = individual_matches_1.super_individual_id)
32. 0.000 0.000 ↓ 0.0

Index Only Scan using individuals_pkey on individuals individuals_1 (cost=0.43..8.37 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = receipts_1.donor_individual_id)
33. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=627,146.73..627,461.71 rows=17,999 width=44) (actual rows= loops=)

  • Group Key: super_individuals_3.id
34. 0.000 0.000 ↓ 0.0

Sort (cost=627,146.73..627,191.73 rows=17,999 width=12) (actual rows= loops=)

  • Sort Key: super_individuals_3.id
35. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,002.16..625,874.60 rows=17,999 width=12) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Index Only Scan using super_committees_pkey on super_committees super_committees_1_2 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = 2054)
37. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.87..625,686.30 rows=17,999 width=16) (actual rows= loops=)

  • Workers Planned: 2
38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.87..622,886.40 rows=7,500 width=16) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.44..563,039.59 rows=7,149 width=24) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..531,498.13 rows=7,149 width=24) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..468,693.73 rows=7,502 width=16) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on committees committees_1_2 (cost=0.00..9,837.64 rows=22 width=8) (actual rows= loops=)

  • Filter: (super_committee_id = 2054)
43. 0.000 0.000 ↓ 0.0

Index Scan using ix_receipts_recipient_committee_id on receipts receipts_2 (cost=0.57..20,803.40 rows=5,369 width=16) (actual rows= loops=)

  • Index Cond: (recipient_committee_id = committees_1_2.id)
44. 0.000 0.000 ↓ 0.0

Index Scan using ix_individual_matches_individual_id on individual_matches individual_matches_2 (cost=0.43..8.37 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (individual_id = receipts_2.donor_individual_id)
45. 0.000 0.000 ↓ 0.0

Index Only Scan using super_individuals_pkey on super_individuals super_individuals_3 (cost=0.43..4.41 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((id = individual_matches_2.super_individual_id) AND (id IS NOT NULL))
46. 0.000 0.000 ↓ 0.0

Index Only Scan using individuals_pkey on individuals individuals_2 (cost=0.43..8.37 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = receipts_2.donor_individual_id)