explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uxVd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=2,398,705.77..2,398,705.78 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on a_mail mail0_ (cost=2,268,886.13..2,398,676.23 rows=118,186 width=8) (actual rows= loops=)

  • Recheck Cond: (to_full_name_ ~~ '%ян%'::text)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on a_mail_to_full_name__idx (cost=0.00..2,268,883.17 rows=118,186 width=0) (actual rows= loops=)

  • Index Cond: (to_full_name_ ~~ '%ян%'::text)