explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z4Hm : Optimization for: plan #gBFi

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.161 12,892.930 ↓ 43.0 43 1

Nested Loop Left Join (cost=238.92..251,217.72 rows=1 width=2,163) (actual time=279.830..12,892.930 rows=43 loops=1)

2. 0.176 12,892.769 ↓ 43.0 43 1

Nested Loop Left Join (cost=238.51..251,212.79 rows=1 width=1,891) (actual time=279.820..12,892.769 rows=43 loops=1)

3. 0.161 12,892.593 ↓ 43.0 43 1

Nested Loop Left Join (cost=238.09..251,207.86 rows=1 width=1,687) (actual time=279.811..12,892.593 rows=43 loops=1)

4. 0.156 12,892.432 ↓ 43.0 43 1

Nested Loop Left Join (cost=237.67..251,202.93 rows=1 width=1,415) (actual time=279.802..12,892.432 rows=43 loops=1)

5. 0.132 12,892.276 ↓ 43.0 43 1

Nested Loop (cost=237.25..251,198.00 rows=1 width=1,211) (actual time=279.794..12,892.276 rows=43 loops=1)

6. 1,155.470 12,891.929 ↓ 43.0 43 1

Nested Loop (cost=236.84..251,189.56 rows=1 width=939) (actual time=279.778..12,891.929 rows=43 loops=1)

7. 1,120.612 7,638.918 ↓ 1,379.6 1,365,847 1

Nested Loop (cost=236.40..246,260.03 rows=990 width=597) (actual time=20.876..7,638.918 rows=1,365,847 loops=1)

8. 1,211.519 1,895.489 ↓ 1,457.8 1,540,939 1

Nested Loop (cost=235.97..240,978.13 rows=1,057 width=544) (actual time=20.860..1,895.489 rows=1,540,939 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. 612.510 683.955 ↓ 48.0 513,646 3

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

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

  • Index Cond: (recipient_committee_id = committees_1.id)
12. 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..5.00 rows=1 width=53) (actual time=0.003..0.003 rows=1 loops=1,540,939)

  • 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.712 ms
Execution time : 12,893.569 ms