explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NweC

Settings
# exclusive inclusive rows x rows loops node
1. 0.332 0.463 ↑ 1.6 1,979 1

Bitmap Heap Scan on layers (cost=109.11..12,306.92 rows=3,167 width=267) (actual time=0.144..0.463 rows=1,979 loops=1)

  • Recheck Cond: ((field_id)::text = '{09698865-5f51-4d19-916d-0c5fabf86132}'::text)
  • Heap Blocks: exact=77
2. 0.131 0.131 ↑ 1.6 1,979 1

Bitmap Index Scan on idx_layers_field_id (cost=0.00..108.32 rows=3,167 width=0) (actual time=0.131..0.131 rows=1,979 loops=1)

  • Index Cond: ((field_id)::text = '{09698865-5f51-4d19-916d-0c5fabf86132}'::text)
Planning time : 0.096 ms
Execution time : 0.559 ms