explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WjRb

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

Seq Scan on appointments (cost=0.00..1.02 rows=1 width=29) (actual time=0.745..0.746 rows=1 loops=1)

  • Filter: (((end_time > '2020-02-03 10:30:17+00'::timestamp with time zone) AND (start_time < '2020-02-03 10:30:17+00'::timestamp with time zone)) OR ((start_time < '2020-02-03 10:30:17+00'::timestamp with time zone) AND (end_time > '2020-02-03 10:00:17+00'::timestamp with time zone)) OR ((end_time > '2020-02-03 10:30:17+00'::timestamp with time zone) AND (end_time < '2020-02-03 10:30:17+00'::timestamp with time zone)))
  • Rows Removed by Filter: 3
Planning time : 2.239 ms
Execution time : 0.785 ms