explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sTse

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 1,542.629 ↑ 65.5 27 1

Sort (cost=2,092.44..2,096.86 rows=1,768 width=20) (actual time=1,542.628..1,542.629 rows=27 loops=1)

  • Sort Key: name
  • Sort Method: quicksort Memory: 27kB
2. 1,542.559 1,542.559 ↑ 65.5 27 1

Index Scan using res_partner_name_idx2 on res_partner (cost=0.42..1,997.08 rows=1,768 width=20) (actual time=102.521..1,542.559 rows=27 loops=1)

  • Index Cond: ((name)::text ~~* '%711%'::text)
  • Filter: active
Planning time : 0.838 ms
Execution time : 1,542.678 ms