explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xy2pz : Optimization for: plan #3AE5

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.208 ↑ 1,000.0 1 1

Subquery Scan on b (cost=0.00..15.25 rows=1,000 width=40) (actual time=0.200..0.208 rows=1 loops=1)

  • Output: b."EGDATETIME", (b.trough).is_trough, (b.trough).difference
2. 0.205 0.205 ↑ 1,000.0 1 1

Result (cost=0.00..5.25 rows=1,000 width=0) (actual time=0.198..0.205 rows=1 loops=1)

  • Output: '2018-10-10 18:59:00'::timestamp without time zone, pg_temp_2.is_at_trough('2018-10-10'::text, '10:00'::text, '2018-10-10 18:59:00'::timestamp without time zone)
Planning time : 0.118 ms
Execution time : 0.228 ms