explain.depesz.com

PostgreSQL's explain analyze made readable

Result: szoo

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 25.188 ↑ 19.0 1 1

Limit (cost=16,388.44..16,388.49 rows=19 width=98) (actual time=25.187..25.188 rows=1 loops=1)

  • Buffers: shared hit=796
2. 0.008 25.186 ↑ 19.0 1 1

Sort (cost=16,388.44..16,388.49 rows=19 width=98) (actual time=25.186..25.186 rows=1 loops=1)

  • Sort Key: name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=796
3. 0.010 25.178 ↑ 19.0 1 1

Bitmap Heap Scan on customer (cost=340.00..16,388.04 rows=19 width=98) (actual time=25.177..25.178 rows=1 loops=1)

  • Recheck Cond: ((customerid = 13,134,237) OR (username ~~* '13134237%'::text) OR (name ~~* '%13134237%'::text))
  • Filter: ((customerstatus <> 'Deleted'::text) AND (resellerid = 247,133) AND ((parentkey = '999999999_247131_247133'::text) OR (parentkey ~~ '999999999\_2
  • Heap Blocks: exact=1
  • Buffers: shared hit=796
4. 0.003 25.168 ↓ 0.0 0 1

BitmapOr (cost=340.00..340.00 rows=4,207 width=0) (actual time=25.168..25.168 rows=0 loops=1)

  • Buffers: shared hit=795
5. 0.010 0.010 ↑ 1.0 1 1

Bitmap Index Scan on customer_pkey (cost=0.00..4.45 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (customerid = 13,134,237)
  • Buffers: shared hit=3
6. 20.827 20.827 ↓ 0.0 0 1

Bitmap Index Scan on customer_username_gin_indx (cost=0.00..204.07 rows=2,142 width=0) (actual time=20.827..20.827 rows=0 loops=1)

  • Index Cond: (username ~~* '13134237%'::text)
  • Buffers: shared hit=694
7. 4.328 4.328 ↓ 0.0 0 1

Bitmap Index Scan on customer_name_gin_indx (cost=0.00..131.48 rows=2,063 width=0) (actual time=4.328..4.328 rows=0 loops=1)

  • Index Cond: (name ~~* '%13134237%'::text)
  • Buffers: shared hit=98
Planning time : 0.500 ms
Execution time : 25.230 ms