explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZaAt : Optimization for: Optimization for: plan #RY9W; plan #eACl

Settings

Optimization path:

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

Limit (cost=5,314.85..5,314.85 rows=15 width=12,854) (actual time=361.859..361.861 rows=6 loops=1)

2. 0.019 361.858 ↑ 676.8 6 1

Sort (cost=5,314.85..5,315.86 rows=4,061 width=12,854) (actual time=361.857..361.858 rows=6 loops=1)

  • Sort Key: id_
  • Sort Method: quicksort Memory: 35kB
3. 0.044 361.839 ↑ 676.8 6 1

Bitmap Heap Scan on a_mail mail0_ (cost=802.42..5,304.88 rows=4,061 width=12,854) (actual time=361.818..361.839 rows=6 loops=1)

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

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

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