explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oPhg : stg

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 64,325.385 ↓ 0.0 0 1

Limit (cost=0.42..87,828.63 rows=20 width=1,189) (actual time=64,325.385..64,325.385 rows=0 loops=1)

2. 64,325.383 64,325.383 ↓ 0.0 0 1

Index Scan Backward using clients_pkey on clients (cost=0.42..377,661.72 rows=86 width=1,189) (actual time=64,325.383..64,325.383 rows=0 loops=1)

  • Filter: ((cpf)::text ~~* '%05068889083%'::text)
  • Rows Removed by Filter: 950,557
Planning time : 44.825 ms
Execution time : 64,326.127 ms