explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HyrS

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

Limit (cost=0.42..71.05 rows=1 width=792) (actual time=0.145..0.146 rows=1 loops=1)

2. 0.144 0.144 ↑ 1.0 1 1

Index Scan using meeting_instance_start_time_meeting_id_idx on meeting_instance "meetingInstance" (cost=0.42..71.05 rows=1 width=792) (actual time=0.143..0.144 rows=1 loops=1)

  • Index Cond: ((start_date_time >= '2020-04-22 10:00:00+00'::timestamp with time zone) AND (start_date_time <= '2020-04-24 10:00:00+00'::timestamp with time zone) AND (meeting_id = '2ea54529-eba3-4929-a15c-53bd8f63294f'::uuid))
Planning time : 0.487 ms
Execution time : 0.191 ms