explain.depesz.com

PostgreSQL's explain analyze made readable

Result: drLG : Optimization for: Optimization for: plan #gBFi; plan #Z4Hm

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.132 38,284.991 ↓ 43.0 43 1

Nested Loop Left Join (cost=238.09..251,155.41 rows=1 width=1,687) (actual time=1,022.648..38,284.991 rows=43 loops=1)

2. 0.144 38,283.784 ↓ 43.0 43 1

Nested Loop Left Join (cost=237.67..251,150.50 rows=1 width=1,415) (actual time=1,022.639..38,283.784 rows=43 loops=1)

3. 0.152 38,282.092 ↓ 43.0 43 1

Nested Loop (cost=237.25..251,145.60 rows=1 width=1,211) (actual time=1,022.630..38,282.092 rows=43 loops=1)

4. 264.785 38,281.725 ↓ 43.0 43 1

Nested Loop (cost=236.84..251,137.16 rows=1 width=939) (actual time=1,022.614..38,281.725 rows=43 loops=1)

5. 1,199.140 18,895.082 ↓ 1,379.6 1,365,847 1

Nested Loop (cost=236.40..246,233.12 rows=990 width=597) (actual time=27.629..18,895.082 rows=1,365,847 loops=1)

6. 1,170.820 11,532.186 ↓ 1,457.8 1,540,939 1

Nested Loop (cost=235.97..240,978.13 rows=1,057 width=544) (actual time=27.609..11,532.186 rows=1,540,939 loops=1)

7. 1.085 1.085 ↑ 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=1.080..1.085 rows=3 loops=1)

  • Index Cond: (super_committee_id = 47823)
8. 8,618.673 10,360.281 ↓ 48.0 513,646 3

Bitmap Heap Scan on receipts (cost=235.55..40,054.36 rows=10,708 width=340) (actual time=584.814..3,453.427 rows=513,646 loops=3)

  • Recheck Cond: (recipient_committee_id = committees_1.id)
  • Heap Blocks: exact=73900
9. 1,741.608 1,741.608 ↓ 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=580.536..580.536 rows=513,646 loops=3)

  • Index Cond: (recipient_committee_id = committees_1.id)
10. 6,163.756 6,163.756 ↑ 1.0 1 1,540,939

Index Scan using ix_individual_matches_individual_id on individual_matches (cost=0.43..4.97 rows=1 width=53) (actual time=0.004..0.004 rows=1 loops=1,540,939)

  • Index Cond: (individual_id = receipts.donor_individual_id)
11. 19,121.858 19,121.858 ↓ 0.0 0 1,365,847

Index Scan using super_individuals_pkey on super_individuals (cost=0.43..4.95 rows=1 width=342) (actual time=0.014..0.014 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
12. 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)
13. 1.548 1.548 ↓ 0.0 0 43

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

  • Index Cond: (receipts.conduit_committee_id = id)
14. 1.075 1.075 ↓ 0.0 0 43

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

  • Index Cond: (committees_3.super_committee_id = id)
Planning time : 14.131 ms
Execution time : 38,285.593 ms