explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f5Vg

Settings
# exclusive inclusive rows x rows loops node
1. 0.252 0.284 ↑ 7.2 87 1

Bitmap Heap Scan on act_bsc_apply (cost=22.49..2,182.88 rows=623 width=478) (actual time=0.047..0.284 rows=87 loops=1)

  • Recheck Cond: (lower((insop)::text) = 'yifang0203@gmail.com'::text)
  • Filter: (((actdate)::text >= '2019-01-01'::text) AND ((actdate)::text <= '2019-04-01'::text))
  • Rows Removed by Filter: 15
  • Heap Blocks: exact=61
2. 0.032 0.032 ↑ 7.7 102 1

Bitmap Index Scan on act_bsc_apply_idx_2 (cost=0.00..22.34 rows=789 width=0) (actual time=0.031..0.032 rows=102 loops=1)

  • Index Cond: (lower((insop)::text) = 'yifang0203@gmail.com'::text)