explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RY9W

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 398.556 ↑ 2.5 6 1

Limit (cost=5,398.45..5,398.45 rows=15 width=12,854) (actual time=398.554..398.556 rows=6 loops=1)

2. 0.020 398.552 ↑ 676.8 6 1

Sort (cost=5,398.45..5,399.46 rows=4,061 width=12,854) (actual time=398.552..398.552 rows=6 loops=1)

  • Sort Key: create_date_
  • Sort Method: quicksort Memory: 35kB
3. 0.065 398.532 ↑ 676.8 6 1

Bitmap Heap Scan on a_mail mail0_ (cost=886.02..5,388.48 rows=4,061 width=12,854) (actual time=398.490..398.532 rows=6 loops=1)

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

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

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