explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mFyw

Settings
# exclusive inclusive rows x rows loops node
1. 481.156 541,422.751 ↑ 2.8 295,662 1

HashAggregate (cost=3,504,124.92..3,512,456.92 rows=833,200 width=60) (actual time=541,346.586..541,422.751 rows=295,662 loops=1)

  • Group Key: o.person_id, ('ALL'::text)
  • Buffers: shared hit=511557 read=1970545
2. 0.000 540,941.595 ↑ 1.0 826,740 1

Gather (cost=1,000.00..3,497,875.92 rows=833,200 width=56) (actual time=5.001..540,941.595 rows=826,740 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=511557 read=1970545
3. 31.079 541,140.323 ↑ 1.3 165,348 5

Result (cost=0.00..3,415,638.92 rows=208,300 width=56) (actual time=9.732..541,140.323 rows=165,348 loops=5)

  • Buffers: shared hit=511557 read=1970545
4. 21.170 541,109.244 ↑ 1.3 165,348 5

Append (cost=0.00..3,413,555.92 rows=208,300 width=24) (actual time=9.731..541,109.244 rows=165,348 loops=5)

  • Buffers: shared hit=511557 read=1970545
5. 0.000 0.000 ↓ 0.0 0 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc o (cost=0.00..0.00 rows=1 width=24) (actual time=0.000..0.000 rows=0 loops=5)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-01 05:59:59.999'::timestamp without time zone) AND ((location_path)::text ~~ '/tax-calculator%'::text))
6. 502.176 502.176 ↑ 1.3 20,495 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 o_1 (cost=0.00..88,308.82 rows=25,633 width=24) (actual time=9.729..502.176 rows=20,495 loops=5)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-01 05:59:59.999'::timestamp without time zone) AND ((location_path)::text ~~ '/tax-calculator%'::text))
  • Rows Removed by Filter: 258638
  • Buffers: shared hit=2 read=58722
7. 3,895.603 3,895.603 ↑ 1.3 70,444 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 o_2 (cost=0.00..733,103.57 rows=88,397 width=24) (actual time=7.194..3,895.603 rows=70,444 loops=5)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-01 05:59:59.999'::timestamp without time zone) AND ((location_path)::text ~~ '/tax-calculator%'::text))
  • Rows Removed by Filter: 2047499
  • Buffers: shared hit=4 read=490550
8. 11,486.468 11,486.468 ↑ 1.3 55,298 5

Parallel Seq Scan on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 o_3 (cost=0.00..1,437,002.33 rows=69,423 width=24) (actual time=6.903..11,486.468 rows=55,298 loops=5)

  • Filter: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-01 05:59:59.999'::timestamp without time zone) AND ((location_path)::text ~~ '/tax-calculator%'::text))
  • Rows Removed by Filter: 4071807
  • Buffers: shared hit=4 read=961952
9. 510,080.798 510,080.798 ↑ 1.2 18,981 5

Parallel Index Only Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_location on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 o_4 (cost=0.81..998,220.18 rows=23,694 width=24) (actual time=437,145.844..510,080.798 rows=18,981 loops=5)

  • Index Cond: ((location_path ~>=~ '/tax-calculator'::text) AND (location_path ~<~ '/tax-calculatos'::text) AND (timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Heap Fetches: 18
  • Buffers: shared hit=6094 read=412081
10. 15,123.029 15,123.029 ↑ 8.8 131 5

Parallel Index Scan using ep_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_ts_pid_ses on event_page_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 o_5 (cost=0.56..156,921.02 rows=1,152 width=24) (actual time=68.592..15,123.029 rows=131 loops=5)

  • Index Cond: ((timestamp_ >= '2019-01-01 07:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-05-01 05:59:59.999'::timestamp without time zone))
  • Filter: ((location_path)::text ~~ '/tax-calculator%'::text)
  • Rows Removed by Filter: 154467
  • Buffers: shared hit=505453 read=47240
Planning time : 66.326 ms
Execution time : 541,451.044 ms