explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OPk0

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

Limit (cost=0.42..493.28 rows=1 width=107) (actual time=0.424..0.426 rows=1 loops=1)

2. 0.424 0.424 ↑ 1.0 1 1

Index Scan using member_id_idx on "checkIn" (cost=0.42..493.28 rows=1 width=107) (actual time=0.423..0.424 rows=1 loops=1)

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