explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QUxv

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 8.917 45,443.598 ↑ 4.9 26,216 1

Finalize GroupAggregate (cost=7,155,849.90..7,179,773.31 rows=128,392 width=60) (actual time=45,402.209..45,443.598 rows=26,216 loops=1)

  • Group Key: person_id, ('ALL'::text)
  • Buffers: shared hit=47088 read=969992
2. 0.000 45,434.681 ↑ 3.6 47,943 1

Gather Merge (cost=7,155,849.90..7,177,199.24 rows=172,020 width=56) (actual time=45,402.202..45,434.681 rows=47,943 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=235268 read=4850993
3. 33.705 226,663.025 ↑ 4.5 9,589 5

Partial GroupAggregate (cost=7,154,849.84..7,155,709.94 rows=43,005 width=56) (actual time=45,322.898..45,332.605 rows=9,589 loops=5)

  • Group Key: person_id, 'ALL'::text
  • Buffers: shared hit=235268 read=4850993
4. 198.770 226,629.320 ↑ 1.3 33,922 5

Sort (cost=7,154,849.84..7,154,957.35 rows=43,005 width=56) (actual time=45,322.891..45,325.864 rows=33,922 loops=5)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 4181kB
  • Buffers: shared hit=235268 read=4850993
5. 226,430.550 226,430.550 ↑ 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=56) (actual time=12.649..45,286.110 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=235056 read=4850993
Planning time : 0.485 ms
Execution time : 45,446.417 ms