explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ewyK

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.348 0.348 ↓ 5.0 5 1

CTE Scan on used (cost=10.43..10.45 rows=1 width=36) (actual time=0.331..0.348 rows=5 loops=1)

2.          

CTE used

3. 0.345 0.345 ↓ 5.0 5 1

Seq Scan on patients (cost=0.00..10.43 rows=1 width=15) (actual time=0.329..0.345 rows=5 loops=1)

  • Filter: ((search ~ 'dn\$11/09/2020\d+\$\|'::text) AND (dossier_nr_updated_date >= '2020-01-01'::date) AND (dossier_nr_updated_date <= '2020-12-31'::date) AND (group_id = 1,036))
  • Rows Removed by Filter: 266
Planning time : 0.257 ms
Execution time : 0.366 ms