explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZuxW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,794.250 ↑ 420.0 1 1

Limit (cost=990,392.18..990,441.19 rows=420 width=98) (actual time=2,794.248..2,794.250 rows=1 loops=1)

  • Buffers: shared hit=31,458 read=112,454
2. 108.917 2,894.885 ↑ 420.0 1 1

Gather Merge (cost=990,392.18..990,441.19 rows=420 width=98) (actual time=2,794.246..2,894.885 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=84,571 read=298,347
3. 0.096 2,785.968 ↓ 0.0 0 3 / 3

Sort (cost=989,392.16..989,392.68 rows=210 width=98) (actual time=2,785.968..2,785.968 rows=0 loops=3)

  • Sort Key: name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=84,571 read=298,347
4. 2,679.238 2,785.872 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on customer (cost=29,695.70..989,384.06 rows=210 width=98) (actual time=2,781.948..2,785.872 rows=0 loops=3)

  • Recheck Cond: (resellerid = 247,133)
  • Filter: ((customerstatus <> 'Deleted'::text) AND (parentkey ~~ '999999999_247131_247133%'::text) AND ((customerid = 13,134,237) OR (lower(username)
  • Rows Removed by Filter: 496,944
  • Heap Blocks: exact=139,046
  • Buffers: shared hit=84,555 read=298,347
5. 106.634 106.634 ↓ 1.0 1,502,472 1 / 3

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

  • Index Cond: (resellerid = 247,133)
  • Buffers: shared hit=1 read=4,865
Planning time : 0.825 ms
Execution time : 2,894.991 ms