explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Yak

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

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

  • Buffers: shared hit=796
2. 0.010 25.150 ↑ 19.0 1 1

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

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

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

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

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

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

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

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

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