explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DOhE

Settings
# exclusive inclusive rows x rows loops node
1. 5,222.694 5,222.694 ↑ 1.0 1 1

Seq Scan on c_order (cost=0.00..438,539.35 rows=1 width=4) (actual time=5,222.654..5,222.694 rows=1 loops=1)

  • Filter: (((c_doctypetarget_id)::text = 'EBB1CE6B19D940C7AE6DFC5A63A0FADD'::text) AND ((docstatus)::text = 'CO'::text) AND ((em_dp_logistics_status)::text = '001'::text) AND (to_char(datepromised, 'dd-mm-yyyy'::text) = to_char(now(), 'dd-mm-yyyy'::text)))
  • Rows Removed by Filter: 2,967,679
Planning time : 0.463 ms
Execution time : 5,222.777 ms