explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ShF8

Settings
# exclusive inclusive rows x rows loops node
1. 81.899 353.336 ↓ 9.4 131,602 1

HashAggregate (cost=25,332.82..25,472.16 rows=13,934 width=4) (actual time=328.669..353.336 rows=131,602 loops=1)

  • Group Key: "DeliverId
2. 234.267 271.437 ↑ 1.1 168,782 1

Bitmap Heap Scan on "RC_KEYWORD" x1 (cost=3,533.58..24,872.96 rows=183,945 width=4) (actual time=40.020..271.437 rows=168,782 loops=1)

  • Recheck Cond: (("Value")::text ~~* ANY ('{%กระทรวง%}'::text[]))
  • Heap Blocks: exact=19234
3. 37.170 37.170 ↑ 1.1 168,783 1

Bitmap Index Scan on "IX_RC_KEYWORD_Value" (cost=0.00..3,487.59 rows=183,945 width=0) (actual time=37.170..37.170 rows=168,783 loops=1)

  • Index Cond: (("Value")::text ~~* ANY ('{%กระทรวง%}'::text[]))
Planning time : 0.285 ms
Execution time : 357.001 ms