explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eACl : Optimization for: plan #RY9W

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 346.841 ↑ 2.5 6 1

Limit (cost=485.62..502.25 rows=15 width=12,854) (actual time=346.822..346.841 rows=6 loops=1)

2. 0.038 346.838 ↑ 676.8 6 1

Bitmap Heap Scan on a_mail mail0_ (cost=485.62..4,988.08 rows=4,061 width=12,854) (actual time=346.820..346.838 rows=6 loops=1)

  • Recheck Cond: (from_full_name_ ~~ '%УСИМХАН ЕРЛАН%'::text)
  • Heap Blocks: exact=6
3. 346.800 346.800 ↑ 676.8 6 1

Bitmap Index Scan on from_full_name_idx (cost=0.00..485.52 rows=4,061 width=0) (actual time=346.800..346.800 rows=6 loops=1)

  • Index Cond: (from_full_name_ ~~ '%УСИМХАН ЕРЛАН%'::text)
Planning time : 2.674 ms
Execution time : 346.999 ms