explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.045 12,855.545 ↓ 43.0 43 1

Limit (cost=203.01..98,954.16 rows=1 width=1,687) (actual time=399.720..12,855.545 rows=43 loops=1)

2. 0.157 12,855.500 ↓ 43.0 43 1

Nested Loop Left Join (cost=203.01..98,954.16 rows=1 width=1,687) (actual time=399.718..12,855.500 rows=43 loops=1)

3. 0.121 12,855.343 ↓ 43.0 43 1

Nested Loop Left Join (cost=202.59..98,949.25 rows=1 width=1,415) (actual time=399.710..12,855.343 rows=43 loops=1)

4. 0.181 12,855.179 ↓ 43.0 43 1

Nested Loop (cost=202.17..98,944.35 rows=1 width=1,211) (actual time=399.700..12,855.179 rows=43 loops=1)

5. 1,165.304 12,854.826 ↓ 43.0 43 1

Nested Loop (cost=201.76..98,935.92 rows=1 width=939) (actual time=399.683..12,854.826 rows=43 loops=1)

6. 1,098.108 7,591.981 ↓ 3,183.8 1,365,847 1

Nested Loop (cost=201.32..96,810.83 rows=429 width=597) (actual time=42.299..7,591.981 rows=1,365,847 loops=1)

7. 1,193.055 1,871.056 ↓ 3,349.9 1,540,939 1

Nested Loop (cost=200.89..94,523.78 rows=460 width=544) (actual time=42.263..1,871.056 rows=1,540,939 loops=1)

8. 0.028 0.028 ↑ 1.0 3 1

Index Scan using committees_pkey on committees committees_1 (cost=0.42..25.31 rows=3 width=204) (actual time=0.013..0.028 rows=3 loops=1)

  • Index Cond: (id = ANY ('{131597,131596,131595}'::integer[]))
9. 607.764 677.973 ↓ 62.3 513,646 3

Bitmap Heap Scan on receipts (cost=200.47..31,417.03 rows=8,246 width=340) (actual time=27.280..225.991 rows=513,646 loops=3)

  • Recheck Cond: (recipient_committee_id = committees_1.id)
  • Heap Blocks: exact=73900
10. 70.209 70.209 ↓ 62.3 513,646 3

Bitmap Index Scan on ix_receipts_recipient_committee_id (cost=0.00..198.41 rows=8,246 width=0) (actual time=23.403..23.403 rows=513,646 loops=3)

  • Index Cond: (recipient_committee_id = committees_1.id)
11. 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)
12. 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.95 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
13. 0.172 0.172 ↑ 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.004 rows=1 loops=43)

  • Index Cond: (id = committees_1.super_committee_id)
14. 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.000..0.001 rows=0 loops=43)

  • Index Cond: (receipts.conduit_committee_id = id)
15. 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.333 ms
Execution time : 12,855.742 ms