explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hoMi

Settings
# exclusive inclusive rows x rows loops node
1. 21.251 1,318,300.536 ↑ 4.9 26,216 1

GroupAggregate (cost=2,975,493.94..2,978,068.10 rows=128,396 width=28) (actual time=1,318,268.162..1,318,300.536 rows=26,216 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=288390 read=1045657
2. 102.500 1,318,279.285 ↑ 1.0 169,608 1

Sort (cost=2,975,493.94..2,975,924.01 rows=172,027 width=24) (actual time=1,318,268.152..1,318,279.285 rows=169,608 loops=1)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 19395kB
  • Buffers: shared hit=288390 read=1045657
3. 1,318,176.785 1,318,176.785 ↑ 1.0 169,608 1

Index Only Scan using max_test_click_2018_3_ix on max_test_click_2018_3 o (cost=0.81..2,960,534.24 rows=172,027 width=24) (actual time=1,223,436.334..1,318,176.785 rows=169,608 loops=1)

  • Index Cond: ((location_path ~>=~ '/tax-calculator'::text) AND (location_path ~<~ '/tax-calculatos'::text) AND (timestamp_ >= '2018-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2018-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Heap Fetches: 169608
  • Buffers: shared hit=288387 read=1045657
Planning time : 3.789 ms
Execution time : 1,318,302.782 ms