explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dcz

Settings
# exclusive inclusive rows x rows loops node
1. 0.574 262.068 ↑ 1.5 164 1

Bitmap Heap Scan on textes (cost=34.37..994.09 rows=252 width=106) (actual time=261.526..262.068 rows=164 loops=1)

  • Recheck Cond: (contenu ~~ '%fantine%'::text)
  • Rows Removed by Index Recheck: 56
  • Heap Blocks: exact=201
2. 261.494 261.494 ↑ 1.1 220 1

Bitmap Index Scan on idx_trgm (cost=0.00..34.30 rows=252 width=0) (actual time=261.494..261.494 rows=220 loops=1)

  • Index Cond: (contenu ~~ '%fantine%'::text)