explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DOJa

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,927.977 ↑ 5.0 1 1

Limit (cost=471,974.80..471,974.82 rows=5 width=47) (actual time=1,927.976..1,927.977 rows=1 loops=1)

2. 0.005 1,927.975 ↑ 5.0 1 1

Sort (cost=471,974.80..471,974.82 rows=5 width=47) (actual time=1,927.974..1,927.975 rows=1 loops=1)

  • Sort Key: (min((segment)::text))
  • Sort Method: quicksort Memory: 25kB
3. 0.010 1,927.970 ↑ 5.0 1 1

WindowAgg (cost=471,970.82..471,974.75 rows=5 width=47) (actual time=1,927.969..1,927.970 rows=1 loops=1)

4. 0.000 1,927.960 ↑ 5.0 1 1

Finalize GroupAggregate (cost=471,970.82..471,974.68 rows=5 width=39) (actual time=1,927.959..1,927.960 rows=1 loops=1)

  • Group Key: segment
5. 0.000 1,930.757 ↑ 4.3 7 1

Gather Merge (cost=471,970.82..471,974.48 rows=30 width=39) (actual time=1,927.948..1,930.757 rows=7 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
6. 0.154 13,433.595 ↑ 5.0 1 7

Sort (cost=470,970.73..470,970.74 rows=5 width=39) (actual time=1,919.085..1,919.085 rows=1 loops=7)

  • Sort Key: segment
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
  • Worker 4: Sort Method: quicksort Memory: 25kB
  • Worker 5: Sort Method: quicksort Memory: 25kB
7. 1,996.015 13,433.441 ↑ 5.0 1 7

Partial HashAggregate (cost=470,970.62..470,970.67 rows=5 width=39) (actual time=1,919.063..1,919.063 rows=1 loops=7)

  • Group Key: segment
8. 11,437.426 11,437.426 ↓ 1.2 567,714 7

Parallel Seq Scan on mall_orders_cz_dwh (cost=0.00..468,669.83 rows=460,158 width=7) (actual time=0.610..1,633.918 rows=567,714 loops=7)

  • Filter: (unaccent(lower((segment)::text)) ~~ '%li%'::text)
  • Rows Removed by Filter: 1404323