explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hymx

Settings
# exclusive inclusive rows x rows loops node
1. 60.625 86,271.600 ↑ 2.3 30,119 1

HashAggregate (cost=117,203.44..117,904.52 rows=70,108 width=28) (actual time=86,265.727..86,271.600 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared read=72867
2. 85,731.501 86,210.975 ↑ 1.0 76,161 1

Bitmap Heap Scan on max_test_2018_3 o (cost=1,170.53..116,821.49 rows=76,390 width=24) (actual time=492.104..86,210.975 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))
  • Heap Blocks: exact=72487
  • Buffers: shared read=72867
3. 479.474 479.474 ↑ 1.0 76,161 1

Bitmap Index Scan on max_test_2018_3_ix (cost=0.00..1,151.43 rows=76,367 width=0) (actual time=479.474..479.474 rows=76,161 loops=1)

  • Index Cond: (((location_path)::text ~>=~ '/tax-calculator'::text) AND ((location_path)::text ~<~ '/tax-calculatos'::text))
  • Buffers: shared read=380
Planning time : 2.048 ms
Execution time : 86,275.214 ms