explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4ByB

Settings
# exclusive inclusive rows x rows loops node
1. 25.970 1,794,866.827 ↑ 4.9 26,216 1

GroupAggregate (cost=2,975,445.08..2,978,449.19 rows=128,392 width=60) (actual time=1,794,830.261..1,794,866.827 rows=26,216 loops=1)

  • Group Key: person_id, 'ALL'::text
  • Buffers: shared hit=2078 read=1331969
2. 124.494 1,794,840.857 ↑ 1.0 169,608 1

Sort (cost=2,975,445.08..2,975,875.12 rows=172,019 width=56) (actual time=1,794,830.251..1,794,840.857 rows=169,608 loops=1)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 19395kB
  • Buffers: shared hit=2078 read=1331969
3. 1,794,716.363 1,794,716.363 ↑ 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,486.12 rows=172,019 width=56) (actual time=1,436,292.931..1,794,716.363 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=2075 read=1331969
Planning time : 1.202 ms
Execution time : 1,794,869.024 ms