explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qKAu

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.070 ↑ 1.0 4 1

Bitmap Heap Scan on phone (cost=4.16..8.49 rows=4 width=63) (actual time=0.066..0.070 rows=4 loops=1)

  • Recheck Cond: (client = ANY ('{e33c25ca-34dc-4a82-abc0-e180e8b97b93,66eeef00-297e-4a02-bc30-ee7c65f73118,4ed9987e-33be-4f80-876c-34914034f54d}'::uuid[]))
  • Heap Blocks: exact=3
2. 0.056 0.056 ↑ 1.0 4 1

Bitmap Index Scan on phones_client_idx (cost=0.00..4.16 rows=4 width=0) (actual time=0.056..0.056 rows=4 loops=1)

  • Index Cond: (client = ANY ('{e33c25ca-34dc-4a82-abc0-e180e8b97b93,66eeef00-297e-4a02-bc30-ee7c65f73118,4ed9987e-33be-4f80-876c-34914034f54d}'::uuid[]))
Planning time : 0.362 ms