explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wn3l

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 398.702 ↓ 0.0 0 1

Sort (cost=4,454.15..4,524.16 rows=28,007 width=8) (actual time=398.701..398.702 rows=0 loops=1)

  • Sort Key: (similarity(client_profile.co_name, $0)) DESC
  • Sort Method: quicksort Memory: 25kB
2.          

Initplan (forSort)

3. 0.000 0.000 ↓ 0.0 0

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) (never executed)

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

Index Only Scan using client_profile_id_co_name_idx on client_profile client_profile_2 (cost=0.41..1.53 rows=1 width=28) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (id = 694743)
  • Heap Fetches: 0
5. 398.696 398.696 ↓ 0.0 0 1

Index Only Scan using client_profile_id_co_name_dba_name_idx on client_profile (cost=0.42..2,382.28 rows=28,007 width=8) (actual time=398.696..398.696 rows=0 loops=1)

  • Filter: (similarity(co_name, $1) > '0.7'::double precision)
  • Rows Removed by Filter: 84022
  • Heap Fetches: 7
Planning time : 0.408 ms
Execution time : 398.743 ms