explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rWZq

Settings
# exclusive inclusive rows x rows loops node
1. 0.796 33,649.437 ↑ 10.3 172 1

Sort (cost=2,092.44..2,096.86 rows=1,768 width=20) (actual time=33,649.431..33,649.437 rows=172 loops=1)

  • Sort Key: name
  • Sort Method: quicksort Memory: 36kB
2. 33,648.641 33,648.641 ↑ 10.3 172 1

Index Scan using res_partner_name_idx2 on res_partner (cost=0.42..1,997.08 rows=1,768 width=20) (actual time=74.462..33,648.641 rows=172 loops=1)

  • Index Cond: ((name)::text ~~* '%71%'::text)
  • Rows Removed by Index Recheck: 18666919
  • Filter: active
Planning time : 0.841 ms
Execution time : 33,649.499 ms