explain.depesz.com

PostgreSQL's explain analyze made readable

Result: shnr

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

Limit (cost=1,000.00..11,446.79 rows=1 width=107) (actual time=16.403..17.586 rows=1 loops=1)

2. 3.391 17.582 ↑ 1.0 1 1

Gather (cost=1,000.00..11,446.79 rows=1 width=107) (actual time=16.402..17.582 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 14.191 14.191 ↓ 0.0 0 3

Parallel Seq Scan on "checkIn" (cost=0.00..10,446.69 rows=1 width=107) (actual time=14.009..14.191 rows=0 loops=3)

  • Filter: ((member_id = '7d4b5f5d-fa9d-4957-a88d-8518d8dd85cf'::uuid) AND (meeting_instance_id = 'cad1e0c1-2885-4502-bfd0-c79468dfd66d'::uuid) AND (checkin_type_id = 1))
  • Rows Removed by Filter: 63188