explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VzTR : Optimization for: plan #ewyK

Settings

Optimization path:

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

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

2.          

CTE used

3. 0.103 0.103 ↓ 5.0 5 1

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

  • Filter: ((search ~~ '%dn$11/09/2020%$|%'::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.134 ms
Execution time : 0.122 ms