explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RaFM

Settings
# exclusive inclusive rows x rows loops node
1. 14.940 1,000,014.568 ↑ 2.3 30,119 1

GroupAggregate (cost=1,488,625.14..1,490,081.32 rows=69,711 width=60) (actual time=999,994.234..1,000,014.568 rows=30,119 loops=1)

  • Group Key: person_id, 'ALL'::text
  • Buffers: shared hit=1536 read=728981
2. 40.158 999,999.628 ↓ 1.0 76,161 1

Sort (cost=1,488,625.14..1,488,814.91 rows=75,907 width=56) (actual time=999,994.224..999,999.628 rows=76,161 loops=1)

  • Sort Key: person_id
  • Sort Method: quicksort Memory: 9023kB
  • Buffers: shared hit=1536 read=728981
3. 999,959.470 999,959.470 ↓ 1.0 76,161 1

Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 o (cost=0.81..1,482,472.14 rows=75,907 width=56) (actual time=838,364.040..999,959.470 rows=76,161 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: 5
  • Buffers: shared hit=1536 read=728981
Planning time : 130.242 ms
Execution time : 1,000,016.362 ms