explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5f2s

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

Limit (cost=16,377.92..16,377.97 rows=19 width=98) (actual time=25.155..25.156 rows=1 loops=1)

  • Buffers: shared hit=796
2. 0.007 25.154 ↑ 19.0 1 1

Sort (cost=16,377.92..16,377.97 rows=19 width=98) (actual time=25.154..25.154 rows=1 loops=1)

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

Bitmap Heap Scan on customer (cost=340.00..16,377.52 rows=19 width=98) (actual time=25.146..25.147 rows=1 loops=1)

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

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

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

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

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

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

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