explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DmuZ : max_test_2018_3 with smaller index

Settings
# exclusive inclusive rows x rows loops node
1. 11.821 635,490.884 ↑ 2.4 30,119 1

GroupAggregate (cost=1,045,470.97..1,046,759.59 rows=70,879 width=28) (actual time=635,475.412..635,490.884 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared hit=2936 read=519124
2. 59.356 635,479.063 ↑ 1.0 76,161 1

Sort (cost=1,045,470.97..1,045,664.25 rows=77,310 width=24) (actual time=635,475.403..635,479.063 rows=76,161 loops=1)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 9023kB
  • Buffers: shared hit=2936 read=519124
3. 635,419.707 635,419.707 ↑ 1.0 76,161 1

Index Scan using max_test_2018_3_ix on max_test_2018_3 o (cost=0.69..1,039,194.03 rows=77,310 width=24) (actual time=470,625.311..635,419.707 rows=76,161 loops=1)

  • Index Cond: (((location_path)::text ~>=~ '/tax-calculator'::text) AND ((location_path)::text ~<~ '/tax-calculatos'::text))
  • 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))
  • Buffers: shared hit=2933 read=519124
Planning time : 1.847 ms
Execution time : 635,492.710 ms