explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z3th

Settings

Optimization(s) for this plan:

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

Limit (cost=1,000.00..14,818.24 rows=1 width=792) (actual time=20.945..22.418 rows=1 loops=1)

2. 3.677 22.414 ↑ 1.0 1 1

Gather (cost=1,000.00..14,818.24 rows=1 width=792) (actual time=20.943..22.414 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 18.737 18.737 ↓ 0.0 0 3 / 3

Parallel Seq Scan on meeting_instance "meetingInstance" (cost=0.00..13,818.14 rows=1 width=792) (actual time=18.197..18.737 rows=0 loops=3)

  • Filter: ((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))
  • Rows Removed by Filter: 97355
Planning time : 0.387 ms
Execution time : 22.470 ms