explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Siu3

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1.476 ↑ 1.0 1 1

Result (cost=1.93..1.94 rows=1 width=1) (actual time=1.474..1.476 rows=1 loops=1)

2.          

Initplan (forResult)

3. 1.472 1.472 ↑ 561.0 1 1

Seq Scan on ps_auction (cost=0.00..1,081.42 rows=561 width=0) (actual time=1.472..1.472 rows=1 loops=1)

  • Filter: (((orgid = 1621) AND (status = 3) AND (actual_end_date >= '2016-01-01 00:00:00'::timestamp without time zone) AND (actual_end_date <= '2019-03-01 00:00:00'::timestamp without time zone)) OR ((status = 1) AND (archived = 'N'::bpchar) AND (start_date >= '2016-01-01 00:00:00'::timestamp without time zone) AND (start_date <= '2019-03-01 00:00:00'::timestamp without time zone)))
  • Rows Removed by Filter: 3542