explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Lxv : with random_page_cost = 2

Settings
# exclusive inclusive rows x rows loops node
1. 69.697 102,808.244 ↑ 2.3 30,119 1

HashAggregate (cost=131,214.65..131,915.85 rows=70,120 width=28) (actual time=102,802.170..102,808.244 rows=30,119 loops=1)

  • Group Key: person_id
  • Buffers: shared read=72867
  • I/O Timings: read=102409.567
2. 102,287.859 102,738.547 ↑ 1.0 76,161 1

Bitmap Heap Scan on max_test_2018_3 o (cost=1,267.33..130,832.62 rows=76,406 width=24) (actual time=463.614..102,738.547 rows=76,161 loops=1)

  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Heap Blocks: exact=72487
  • Buffers: shared read=72867
  • I/O Timings: read=102409.567
3. 450.688 450.688 ↑ 1.0 76,161 1

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

  • Index Cond: (((location_path)::text ~>=~ '/tax-calculator'::text) AND ((location_path)::text ~<~ '/tax-calculatos'::text))
  • Buffers: shared read=380
  • I/O Timings: read=431.862
Planning time : 12.065 ms
Execution time : 102,811.842 ms