explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RRy9

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 0.097 ↑ 6.0 10 1

Unique (cost=0.42..45.45 rows=60 width=36) (actual time=0.036..0.097 rows=10 loops=1)

2. 0.093 0.093 ↑ 6.0 10 1

Index Only Scan using ix_personstatus_personid_isdeleted on personstatus ps (cost=0.42..45.30 rows=60 width=36) (actual time=0.035..0.093 rows=10 loops=1)

  • Index Cond: (personid = ANY ('{2343cc01-2b16-4d68-87bc-90d6690d41b0,40b8c436-bbf8-4551-bd89-e250d1805dde,ef5cb90b-1b13-4fc2-a4e3-6d85b2efe099,da8fbac1-d451-453e-ba9a-5ac467939a1c,e67a3ac3-c393-4843-8206-1f61f7a8987c,c1376958-6077-4191-85bd-3230b03dbaea,c18cb37b-3343-4268-b82b-07343674dad9,d43e227a-9b09-42ae-9c9f-84f2e08a1ca6,1ac3ea5e-4488-42c9-bbec-f9b3fe4d044b,264b0836-a24d-47d5-a764-63ebbd354087}'::text[]))
  • Heap Fetches: 0
Planning time : 0.143 ms
Execution time : 0.109 ms