explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c1Do : Optimization for: plan #Kr34

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.196 189,288.487 ↑ 1.0 1 1

Aggregate (cost=1,049,218.61..1,049,218.62 rows=1 width=8) (actual time=189,288.487..189,288.487 rows=1 loops=1)

2. 189,288.291 189,288.291 ↑ 1.3 732 1

Seq Scan on pc_history_work (cost=0.00..1,049,216.26 rows=939 width=78) (actual time=163,330.031..189,288.291 rows=732 loops=1)

  • Filter: ((pxcommitdatetime >= '2019-04-02 02:39:48.112'::timestamp without time zone) AND ((pzinskey)::text ~~ 'HISTORY-SG-ADMISSIONS-WORK%'::text))
  • Rows Removed by Filter: 5867772
Planning time : 0.142 ms
Execution time : 189,288.539 ms