explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cZdH : Optimization for: plan #2QsO

Settings

Optimization path:

Optimization(s) for this plan:

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

Limit (cost=38,869.39..42,995.77 rows=100 width=340) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=38,869.39..389,653.23 rows=8,501 width=340) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=38,868.82..38,883.41 rows=1,459 width=8) (actual rows= loops=)

  • Group Key: individuals.id
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,896.05..38,865.17 rows=1,459 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,895.61..33,200.23 rows=1,459 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on super_individuals (cost=3,895.18..7,319.53 rows=898 width=4) (actual rows= loops=)

  • Recheck Cond: ((employer_tsvector @@ '''facebook'':*'::tsquery) OR (employer_tsvector @@ '''google'':*'::tsquery))
7. 0.000 0.000 ↓ 0.0

BitmapOr (cost=3,895.18..3,895.18 rows=898 width=0) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_super_individuals_employer_tsvector (cost=0.00..1,947.37 rows=449 width=0) (actual rows= loops=)

  • Index Cond: (employer_tsvector @@ '''facebook'':*'::tsquery)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_super_individuals_employer_tsvector (cost=0.00..1,947.37 rows=449 width=0) (actual rows= loops=)

  • Index Cond: (employer_tsvector @@ '''google'':*'::tsquery)
10. 0.000 0.000 ↓ 0.0

Index Scan using ix_individual_matches_super_individual_id on individual_matches (cost=0.43..28.75 rows=7 width=8) (actual rows= loops=)

  • Index Cond: (super_individual_id = super_individuals.id)
11. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = individual_matches.individual_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using ix_receipts_donor_individual_id on receipts (cost=0.56..240.36 rows=6 width=340) (actual rows= loops=)

  • Index Cond: (donor_individual_id = individuals.id)
  • Filter: (recipient_committee_id = ANY ('{131597,131596,131595}'::integer[]))