explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LRCq

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 9,125.401 ↑ 119.5 2 1

Bitmap Heap Scan on customers (cost=14.26..942.84 rows=239 width=8) (actual time=9,125.384..9,125.401 rows=2 loops=1)

  • Recheck Cond: (referral_code ~~ 'RXK%'::text)
  • Filter: (deleted_at IS NULL)
  • Heap Blocks: exact=2
2. 9,125.361 9,125.361 ↑ 119.5 2 1

Bitmap Index Scan on customers_referral_code_idx (cost=0.00..14.21 rows=239 width=0) (actual time=9,125.361..9,125.361 rows=2 loops=1)

  • Index Cond: (referral_code ~~ 'RXK%'::text)
Planning time : 0.101 ms