explain.depesz.com

PostgreSQL's explain analyze made readable

Result: btWj : Optimization for: plan #RRy9

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 6.030 ↓ 1.2 10 1

Unique (cost=278.85..278.89 rows=8 width=36) (actual time=6.027..6.030 rows=10 loops=1)

2. 0.012 6.027 ↓ 1.2 10 1

Sort (cost=278.85..278.87 rows=8 width=36) (actual time=6.027..6.027 rows=10 loops=1)

  • Sort Key: personid
  • Sort Method: quicksort Memory: 25kB
3. 0.110 6.015 ↓ 1.2 10 1

Bitmap Heap Scan on personstatus cs (cost=44.70..278.73 rows=8 width=36) (actual time=5.918..6.015 rows=10 loops=1)

  • Recheck Cond: (((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[])) AND (NOT isdeleted))
  • Filter: (((shipcode)::text = 'SC'::text) AND ((statustypecode)::text = 'TC'::text) AND ((status)::text = 'COMPLETED'::text))
  • Rows Removed by Filter: 60
  • Heap Blocks: exact=64
4. 5.905 5.905 ↓ 1.2 70 1

Bitmap Index Scan on ix_personstatus_personid_isdeleted (cost=0.00..44.70 rows=60 width=0) (actual time=5.905..5.905 rows=70 loops=1)

  • Index Cond: ((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[]))
Planning time : 0.185 ms
Execution time : 6.059 ms