explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CRLU : Optimization for: plan #gBFi

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.166 15,084.645 ↓ 43.0 43 1

Nested Loop Left Join (cost=238.09..251,155.41 rows=1 width=1,687) (actual time=297.097..15,084.645 rows=43 loops=1)

2. 0.139 15,084.479 ↓ 43.0 43 1

Nested Loop Left Join (cost=237.67..251,150.50 rows=1 width=1,415) (actual time=297.087..15,084.479 rows=43 loops=1)

3. 0.158 15,084.297 ↓ 43.0 43 1

Nested Loop (cost=237.25..251,145.60 rows=1 width=1,211) (actual time=297.078..15,084.297 rows=43 loops=1)

4. 1,206.624 15,083.924 ↓ 43.0 43 1

Nested Loop (cost=236.84..251,137.16 rows=1 width=939) (actual time=297.061..15,083.924 rows=43 loops=1)

5. 1,792.603 8,413.912 ↓ 1,379.6 1,365,847 1

Nested Loop (cost=236.40..246,233.12 rows=990 width=597) (actual time=20.494..8,413.912 rows=1,365,847 loops=1)

6. 1,236.006 1,998.492 ↓ 1,457.8 1,540,939 1

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

7. 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.011..0.015 rows=3 loops=1)

  • Index Cond: (super_committee_id = 47823)
8. 690.033 762.471 ↓ 48.0 513,646 3

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

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

  • Index Cond: (recipient_committee_id = committees_1.id)
10. 4,622.817 4,622.817 ↑ 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.003..0.003 rows=1 loops=1,540,939)

  • Index Cond: (individual_id = receipts.donor_individual_id)
11. 5,463.388 5,463.388 ↓ 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.004..0.004 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.005..0.005 rows=1 loops=43)

  • Index Cond: (id = 47823)
13. 0.043 0.043 ↓ 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.001..0.001 rows=0 loops=43)

  • Index Cond: (receipts.conduit_committee_id = id)
14. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=43)

  • Index Cond: (committees_3.super_committee_id = id)
Planning time : 3.125 ms
Execution time : 15,085.280 ms