explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rx6

Settings
# exclusive inclusive rows x rows loops node
1. 15.301 33,923.875 ↓ 1,158.4 30,119 1

GroupAggregate (cost=1,572,840.25..1,572,840.79 rows=26 width=60) (actual time=33,902.361..33,923.875 rows=30,119 loops=1)

  • Group Key: person_id, 'ALL'::text
  • Buffers: shared hit=3 read=1109587
2. 54.783 33,908.574 ↓ 2,720.0 76,161 1

Sort (cost=1,572,840.25..1,572,840.32 rows=28 width=56) (actual time=33,902.352..33,908.574 rows=76,161 loops=1)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 9023kB
  • Buffers: shared hit=3 read=1109587
3. 33,853.791 33,853.791 ↓ 2,720.0 76,161 1

Seq Scan on max_test2_2018_3 o (cost=0.00..1,572,839.57 rows=28 width=56) (actual time=7.881..33,853.791 rows=76,161 loops=1)

  • 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: 17727761
  • Buffers: shared read=1109587
Planning time : 79.285 ms
Execution time : 33,925.729 ms