explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aZ3a

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 25.110 ↑ 19.0 1 1

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

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

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

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

Bitmap Heap Scan on customer (cost=340.00..16,388.04 rows=19 width=98) (actual time=25.101..25.101 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.001 25.091 ↓ 0.0 0 1

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

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

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

  • Index Cond: (customerid = 13,134,237)
  • Buffers: shared hit=3
6. 20.829 20.829 ↓ 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.829..20.829 rows=0 loops=1)

  • Index Cond: (username ~~* '13134237%'::text)
  • Buffers: shared hit=694
7. 4.252 4.252 ↓ 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.252..4.252 rows=0 loops=1)

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