explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pY9l

Settings
# exclusive inclusive rows x rows loops node
1. 1.900 26.256 ↓ 3.9 4,358 1

HashAggregate (cost=20,964.84..20,975.99 rows=1,115 width=4) (actual time=25.808..26.256 rows=4,358 loops=1)

  • Group Key: "DeliverId
2. 18.986 24.356 ↑ 2.2 6,789 1

Bitmap Heap Scan on "RC_KEYWORD" x1 (cost=1,914.06..20,928.04 rows=14,718 width=4) (actual time=5.839..24.356 rows=6,789 loops=1)

  • Recheck Cond: (("Value")::text ~~* ANY ('{%ข้าว%}'::text[]))
  • Rows Removed by Index Recheck: 26
  • Heap Blocks: exact=4203
3. 5.370 5.370 ↑ 2.2 6,815 1

Bitmap Index Scan on "IX_RC_KEYWORD_Value" (cost=0.00..1,910.38 rows=14,718 width=0) (actual time=5.370..5.370 rows=6,815 loops=1)

  • Index Cond: (("Value")::text ~~* ANY ('{%ข้าว%}'::text[]))
Planning time : 0.271 ms
Execution time : 26.410 ms