explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qx77

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 7,591.863 ↑ 500.0 1 1

Limit (cost=368,716.68..368,717.93 rows=500 width=98) (actual time=7,591.861..7,591.863 rows=1 loops=1)

  • Buffers: shared hit=84,591 read=309,729
2. 0.110 7,591.857 ↑ 502.0 1 1

Sort (cost=368,716.68..368,717.93 rows=502 width=98) (actual time=7,591.856..7,591.857 rows=1 loops=1)

  • Sort Key: name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=84,591 read=309,729
3. 6,281.912 7,591.747 ↑ 502.0 1 1

Bitmap Heap Scan on customer (cost=75,966.69..368,694.16 rows=502 width=98) (actual time=7,561.086..7,591.747 rows=1 loops=1)

  • Recheck Cond: ((resellerid = 247,133) AND ((parentkey = '999999999_247131_247133'::text) OR (parentkey ~~ '999999999\_247131\_247133\%'::text)))
  • Filter: ((customerstatus <> 'Deleted'::text) AND ((parentkey = '999999999_247131_247133'::text) OR (parentkey ~~ '999999999\_247131\_247133\%'::text)) A
  • Rows Removed by Filter: 1,490,833
  • Heap Blocks: exact=378,013
  • Buffers: shared hit=84,588 read=309,729
4. 20.904 1,309.835 ↓ 0.0 0 1

BitmapAnd (cost=75,966.69..75,966.69 rows=101,021 width=0) (actual time=1,309.835..1,309.835 rows=0 loops=1)

  • Buffers: shared hit=4 read=16,300
5. 550.653 550.653 ↓ 1.0 1,502,472 1

Bitmap Index Scan on customer_resellerid_key1 (cost=0.00..29,695.57 rows=1,475,618 width=0) (actual time=550.653..550.653 rows=1,502,472 loops=1)

  • Index Cond: (resellerid = 247,133)
  • Buffers: shared hit=1 read=4,865
6. 738.224 738.278 ↓ 0.0 0 1

BitmapOr (cost=46,270.75..46,270.75 rows=1,475,916 width=0) (actual time=738.278..738.278 rows=0 loops=1)

  • Buffers: shared hit=3 read=11,435
  • -> Bitmap Index Scan on customer_parentkey_idx (cost=0.00..46259.70 rows=1,475,618 width=0) (actual time=738.217..738.217 rows=1,502,774 loops
  • Index Cond: (parentkey = '999999999_247131_247133'::text)
  • Buffers: shared read=11,434
7. 0.054 0.054 ↓ 0.0 0 1

Bitmap Index Scan on customer_parentkey_idx (cost=0.00..10.80 rows=298 width=0) (actual time=0.054..0.054 rows=0 loops=1)

  • Index Cond: (parentkey = '999999999_247131_247133%'::text)
  • Buffers: shared hit=3 read=1
Planning time : 3.082 ms
Execution time : 7,594.924 ms