explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PLZi : Optimization for: plan #RRy9

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 65.549 ↓ 0.0 0 1

Unique (cost=76,290.22..76,290.23 rows=1 width=36) (actual time=65.549..65.549 rows=0 loops=1)

2. 0.004 65.549 ↓ 0.0 0 1

Sort (cost=76,290.22..76,290.23 rows=1 width=36) (actual time=65.549..65.549 rows=0 loops=1)

  • Sort Key: ps.personid
  • Sort Method: quicksort Memory: 25kB
3. 0.000 65.545 ↓ 0.0 0 1

Nested Loop Anti Join (cost=2,000.00..76,290.21 rows=1 width=36) (actual time=65.545..65.545 rows=0 loops=1)

  • Join Filter: ((p.personid)::text = (ps.personid)::text)
4. 16.648 79.216 ↓ 0.0 0 1

Gather (cost=1,000.00..39,564.95 rows=1 width=36) (actual time=65.544..79.216 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 62.568 62.568 ↓ 0.0 0 3

Parallel Seq Scan on personstatus ps (cost=0.00..38,564.85 rows=1 width=36) (actual time=62.568..62.568 rows=0 loops=3)

  • Filter: (isdeleted AND ((personid)::text = ANY ('{d22ddfa3-94a5-4fb1-ae59-49f340bbd0ff,0392a6b3-f89b-4b2d-b2e7-4315f24f1146,01e5b1f0-faae-42d8-8e11-dc517d48caad,7f9b2fbe-1378-4a5f-b0fe-bd5895ac04f1,6c86dfdb-e1e2-47ec-ae7e-cdb7844b880b,8215761a-8fb6-47fd-9ec0-e2226947aa9d,06b93acc-81d4-43db-9d6d-bec10daee09d,51ffc8aa-0cb4-4288-b975-90a8ddeaea45,87b209bb-784b-4960-ab1f-4b8584e2cd37,9024336c-9f5c-4f8f-89dd-0d16c09791ca}'::text[])))
  • Rows Removed by Filter: 225880
6. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..36,725.17 rows=7 width=36) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
7. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on personstatus p (cost=0.00..35,724.47 rows=3 width=36) (never executed)

  • Filter: (isdeleted AND ((statustypecode)::text = 'BS'::text))
Planning time : 0.243 ms
Execution time : 79.250 ms