explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g9P3

Settings
# exclusive inclusive rows x rows loops node
1. 25.874 3,470.004 ↑ 4.9 26,216 1

GroupAggregate (cost=2,975,445.08..2,978,449.19 rows=128,392 width=60) (actual time=3,433.936..3,470.004 rows=26,216 loops=1)

  • Group Key: person_id, 'ALL'::text
  • Buffers: shared hit=1334047
2. 76.907 3,444.130 ↑ 1.0 169,608 1

Sort (cost=2,975,445.08..2,975,875.12 rows=172,019 width=56) (actual time=3,433.928..3,444.130 rows=169,608 loops=1)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 19395kB
  • Buffers: shared hit=1334047
3. 3,367.223 3,367.223 ↑ 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=2,829.691..3,367.223 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=1334044
Planning time : 2.773 ms
Execution time : 3,472.176 ms