explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jAscK

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

Limit (cost=0.00..16.14 rows=1 width=320) (actual time=0.052..0.053 rows=1 loops=1)

2. 0.049 0.049 ↑ 3.0 1 1

Seq Scan on order_suborder_view o (cost=0.00..48.41 rows=3 width=320) (actual time=0.049..0.049 rows=1 loops=1)

  • Filter: (((countryid)::text = 'CL'::text) AND (((clientid)::text = '132828563'::text) OR ((retreatid)::text = '132828563'::text)))
  • Rows Removed by Filter: 83
Planning time : 1.266 ms
Execution time : 0.080 ms