explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YOmd

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.031 ↑ 5,000.0 1 1

Bitmap Heap Scan on products (cost=146.75..11,623.66 rows=5,000 width=170) (actual time=0.028..0.031 rows=1 loops=1)

  • Recheck Cond: (tags @> '{1111}'::text[])
  • Heap Blocks: exact=1
  • Execution Time: 0.086 ms(7 строк)
2. 0.019 0.019 ↑ 5,000.0 1 1

Bitmap Index Scan on products_tags_new (cost=0.00..145.50 rows=5,000 width=0) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (tags @> '{1111}'::text[])
Planning time : 0.212 ms