explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kr34

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 2,224.726 ↓ 0.0 0 1

Insert on pr_log (cost=657,765.18..657,765.20 rows=1 width=2,020) (actual time=2,224.726..2,224.726 rows=0 loops=1)

2.          

Initplan (forInsert)

3. 0.008 2,224.583 ↑ 1.0 1 1

Aggregate (cost=657,765.17..657,765.18 rows=1 width=8) (actual time=2,224.583..2,224.583 rows=1 loops=1)

4. 2,224.575 2,224.575 ↓ 0.0 0 1

Seq Scan on pr_log pr_log_1 (cost=0.00..657,765.17 rows=1 width=0) (actual time=2,224.575..2,224.575 rows=0 loops=1)

  • Filter: (((pyproperties)::text = 'RULE-ADMIN-EXTRACT INDEX-SG-ADMISSIONS-DATA EXTRACTCORRDETAILS #20180215T095432.894 GMT'::text) AND (to_char((date(pxcreatedatetime))::timestamp with time zone, 'yyyy-MM-dd'::text) = '2019-04-03'::text))
  • Rows Removed by Filter: 4446854
5. 2,224.595 2,224.595 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=2,020) (actual time=2,224.594..2,224.595 rows=1 loops=1)

Planning time : 0.286 ms
Execution time : 2,224.805 ms