explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gBFi

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.181 12,860.960 ↓ 43.0 43 1

Nested Loop Left Join (cost=238.75..250,527.45 rows=1 width=2,163) (actual time=275.597..12,860.960 rows=43 loops=1)

2. 0.164 12,860.779 ↓ 43.0 43 1

Nested Loop Left Join (cost=238.34..250,522.51 rows=1 width=1,891) (actual time=275.587..12,860.779 rows=43 loops=1)

3. 0.162 12,860.615 ↓ 43.0 43 1

Nested Loop Left Join (cost=237.92..250,517.58 rows=1 width=1,687) (actual time=275.578..12,860.615 rows=43 loops=1)

4. 0.156 12,860.453 ↓ 43.0 43 1

Nested Loop Left Join (cost=237.50..250,512.65 rows=1 width=1,415) (actual time=275.569..12,860.453 rows=43 loops=1)

5. 0.130 12,860.297 ↓ 43.0 43 1

Nested Loop (cost=237.08..250,507.72 rows=1 width=1,211) (actual time=275.559..12,860.297 rows=43 loops=1)

6. 1,152.440 12,859.952 ↓ 43.0 43 1

Nested Loop (cost=236.67..250,499.28 rows=1 width=939) (actual time=275.539..12,859.952 rows=43 loops=1)

7. 1,061.285 7,609.971 ↓ 1,473.4 1,365,847 1

Nested Loop (cost=236.23..245,883.45 rows=927 width=597) (actual time=19.400..7,609.971 rows=1,365,847 loops=1)

8. 1,170.112 1,926.847 ↓ 1,556.2 1,540,613 1

Nested Loop (cost=235.80..240,936.25 rows=990 width=544) (actual time=19.385..1,926.847 rows=1,540,613 loops=1)

9. 0.015 0.015 ↑ 2.0 3 1

Index Scan using ix_committees_super_committee_id on committees committees_1 (cost=0.42..9.51 rows=6 width=204) (actual time=0.010..0.015 rows=3 loops=1)

  • Index Cond: (super_committee_id = 47823)
10. 686.955 756.720 ↓ 51.2 513,538 3

Bitmap Heap Scan on receipts (cost=235.38..40,054.19 rows=10,027 width=340) (actual time=27.139..252.240 rows=513,538 loops=3)

  • Recheck Cond: (recipient_committee_id = committees_1.id)
  • Filter: (donor_individual_id IS NOT NULL)
  • Rows Removed by Filter: 109
  • Heap Blocks: exact=73900
11. 69.765 69.765 ↓ 48.0 513,646 3

Bitmap Index Scan on ix_receipts_recipient_committee_id (cost=0.00..232.88 rows=10,708 width=0) (actual time=23.255..23.255 rows=513,646 loops=3)

  • Index Cond: (recipient_committee_id = committees_1.id)
12. 4,621.839 4,621.839 ↑ 1.0 1 1,540,613

Index Scan using ix_individual_matches_individual_id on individual_matches (cost=0.43..5.00 rows=1 width=53) (actual time=0.003..0.003 rows=1 loops=1,540,613)

  • Index Cond: (individual_id = receipts.donor_individual_id)
13. 4,097.541 4,097.541 ↓ 0.0 0 1,365,847

Index Scan using super_individuals_pkey on super_individuals (cost=0.43..4.98 rows=1 width=342) (actual time=0.003..0.003 rows=0 loops=1,365,847)

  • Index Cond: (id = individual_matches.super_individual_id)
  • Filter: ((employer_tsvector @@ '''facebook'':*'::tsquery) OR (employer_tsvector @@ '''google'':*'::tsquery))
  • Rows Removed by Filter: 1
14. 0.215 0.215 ↑ 1.0 1 43

Index Scan using super_committees_pkey on super_committees super_committees_1 (cost=0.41..8.43 rows=1 width=272) (actual time=0.004..0.005 rows=1 loops=43)

  • Index Cond: (id = 47823)
15. 0.000 0.000 ↓ 0.0 0 43

Index Scan using committees_pkey on committees committees_2 (cost=0.42..4.93 rows=1 width=204) (actual time=0.000..0.000 rows=0 loops=43)

  • Index Cond: (receipts.donor_committee_id = id)
16. 0.000 0.000 ↓ 0.0 0 43

Index Scan using super_committees_pkey on super_committees super_committees_3 (cost=0.41..4.93 rows=1 width=272) (actual time=0.000..0.000 rows=0 loops=43)

  • Index Cond: (committees_2.super_committee_id = id)
17. 0.000 0.000 ↓ 0.0 0 43

Index Scan using committees_pkey on committees committees_3 (cost=0.42..4.93 rows=1 width=204) (actual time=0.000..0.000 rows=0 loops=43)

  • Index Cond: (receipts.conduit_committee_id = id)
18. 0.000 0.000 ↓ 0.0 0 43

Index Scan using super_committees_pkey on super_committees super_committees_2 (cost=0.41..4.93 rows=1 width=272) (actual time=0.000..0.000 rows=0 loops=43)

  • Index Cond: (committees_3.super_committee_id = id)
Planning time : 3.844 ms
Execution time : 12,861.632 ms