explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MQdH

Settings
# exclusive inclusive rows x rows loops node
1. 0.241 2,032.854 ↑ 115,477.1 150 1

Unique (cost=148,726,115.48..149,220,153.16 rows=17,321,566 width=168) (actual time=2,032.566..2,032.854 rows=150 loops=1)

2.          

CTE similar_names_cte

3. 0.153 0.153 ↑ 1.0 234 1

Seq Scan on similar_names_dev (cost=0.00..4.34 rows=234 width=7) (actual time=0.016..0.153 rows=234 loops=1)

4. 2.093 2,032.613 ↑ 36,595.4 1,080 1

Sort (cost=148,726,111.14..148,824,918.68 rows=39,523,014 width=168) (actual time=2,032.566..2,032.613 rows=1,080 loops=1)

  • Sort Key: fec.name, fec.state, fec.city, fec.zip_code
  • Sort Method: quicksort Memory: 197kB
5. 1.332 2,030.520 ↑ 36,595.4 1,080 1

Nested Loop (cost=8,345.31..139,941,143.66 rows=39,523,014 width=168) (actual time=97.336..2,030.520 rows=1,080 loops=1)

6. 0.408 0.408 ↑ 1.0 234 1

CTE Scan on similar_names_cte sn1 (cost=0.00..4.68 rows=234 width=32) (actual time=0.018..0.408 rows=234 loops=1)

7. 26.208 2,028.780 ↑ 33,780.4 5 234

Bitmap Heap Scan on contributions_fec_contributions fec (cost=8,345.31..596,350.04 rows=168,902 width=36) (actual time=8.590..8.670 rows=5 loops=234)

  • Recheck Cond: (to_tsvector('simple'::regconfig, (name)::text) @@ plainto_tsquery((((sn1.name)::text || ' '::text) || 'Smith'::text)))
  • Filter: ((state IS NULL) OR (lower((state)::text) = 'ca'::text))
  • Rows Removed by Filter: 38
  • Heap Blocks: exact=9409
8. 2,002.572 2,002.572 ↑ 24,318.1 43 234

Bitmap Index Scan on ix_contributions_fec_contributions_name_tsv_simple (cost=0.00..8,303.09 rows=1,045,678 width=0) (actual time=8.558..8.558 rows=43 loops=234)

  • Index Cond: (to_tsvector('simple'::regconfig, (name)::text) @@ plainto_tsquery((((sn1.name)::text || ' '::text) || 'Smith'::text)))