explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lQo4

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.027 ↑ 5,000.0 1 1

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

  • Recheck Cond: (tags @> '{1111}'::text[])
  • Heap Blocks: exact=1
  • Execution Time: 0.085 ms(7 строк)
2. 0.018 0.018 ↑ 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.018 rows=1 loops=1)

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