explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I4Bf : Optimization for: plan #QUxv

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 8.551 4,309.099 ↑ 4.9 26,216 1

Finalize GroupAggregate (cost=7,155,849.90..7,179,235.75 rows=128,392 width=28) (actual time=4,270.970..4,309.099 rows=26,216 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=1999901
2. 0.000 4,300.548 ↑ 3.6 48,036 1

Gather Merge (cost=7,155,849.90..7,177,091.73 rows=172,020 width=24) (actual time=4,270.965..4,300.548 rows=48,036 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=9937180 read=5
3. 27.180 21,340.200 ↑ 4.5 9,607 5

Partial GroupAggregate (cost=7,154,849.84..7,155,602.43 rows=43,005 width=24) (actual time=4,259.920..4,268.040 rows=9,607 loops=5)

  • Group Key: person_id
  • Buffers: shared hit=9937180 read=5
4. 85.965 21,313.020 ↑ 1.3 33,922 5

Sort (cost=7,154,849.84..7,154,957.35 rows=43,005 width=24) (actual time=4,259.914..4,262.604 rows=33,922 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 4187kB
  • Buffers: shared hit=9937180 read=5
5. 21,227.055 21,227.055 ↑ 1.3 33,922 5

Parallel Seq Scan on max_test_click_2018_3 o (cost=0.00..7,151,540.13 rows=43,005 width=24) (actual time=0.423..4,245.411 rows=33,922 loops=5)

  • Filter: ((timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone) AND ((location_path)::text ~~ '/tax-calculator%'::text))
  • Rows Removed by Filter: 8908475
  • Buffers: shared hit=9936968 read=5
Planning time : 0.630 ms
Execution time : 4,310.721 ms