explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fnd8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 831.707 ↑ 28,007.0 1 1

Sort (cost=7,709.86..7,779.88 rows=28,007 width=8) (actual time=831.707..831.707 rows=1 loops=1)

  • Sort Key: (((((similarity(client_profile.co_name, $0) + similarity(client_profile.addr1, $1)) + similarity(client_profile.city, $2)) + similarity(client_profile.state, $3)) + similarity(client_profile.zip, $4))) DESC
  • Sort Method: quicksort Memory: 25kB
2.          

Initplan (forSort)

3. 0.029 0.029 ↑ 1.0 1 1

Index Only Scan using client_profile_id_co_name_idx on client_profile client_profile_1 (cost=0.41..1.53 rows=1 width=28) (actual time=0.028..0.029 rows=1 loops=1)

  • Index Cond: (id = 704228)
  • Heap Fetches: 0
4. 0.015 0.015 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_2 (cost=0.29..2.51 rows=1 width=18) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (id = 704228)
5. 0.018 0.018 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_3 (cost=0.29..2.51 rows=1 width=9) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (id = 704228)
6. 0.017 0.017 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_4 (cost=0.29..2.51 rows=1 width=3) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (id = 704228)
7. 0.007 0.007 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_5 (cost=0.29..2.51 rows=1 width=6) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = 704228)
8. 0.036 0.036 ↑ 1.0 1 1

Index Only Scan using client_profile_id_co_name_idx on client_profile client_profile_6 (cost=0.41..1.53 rows=1 width=28) (actual time=0.035..0.036 rows=1 loops=1)

  • Index Cond: (id = 704228)
  • Heap Fetches: 0
9. 0.014 0.014 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_7 (cost=0.29..2.51 rows=1 width=18) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (id = 704228)
10. 0.009 0.009 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_8 (cost=0.29..2.51 rows=1 width=9) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = 704228)
11. 0.006 0.006 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_9 (cost=0.29..2.51 rows=1 width=3) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (id = 704228)
12. 0.007 0.007 ↑ 1.0 1 1

Index Scan using client_profile_pkey on client_profile client_profile_10 (cost=0.29..2.51 rows=1 width=6) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (id = 704228)
13. 831.691 831.691 ↑ 28,007.0 1 1

Seq Scan on client_profile (cost=0.00..5,617.93 rows=28,007 width=8) (actual time=831.690..831.691 rows=1 loops=1)

  • Filter: (((((similarity(co_name, $5) + similarity(addr1, $6)) + similarity(city, $7)) + similarity(state, $8)) + similarity(zip, $9)) >= '4'::double precision)
  • Rows Removed by Filter: 84023