explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oBoZ

Settings
# exclusive inclusive rows x rows loops node
1. 316.773 2,522.677 ↑ 2.8 295,662 1

HashAggregate (cost=3,504,124.92..3,512,456.92 rows=833,200 width=60) (actual time=2,444.448..2,522.677 rows=295,662 loops=1)

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

Gather (cost=1,000.00..3,497,875.92 rows=833,200 width=56) (actual time=0.836..2,205.904 rows=826,740 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=3992899 read=1
3. 17.703 2,285.404 ↑ 1.3 165,348 5

Result (cost=0.00..3,415,638.92 rows=208,300 width=56) (actual time=0.167..2,285.404 rows=165,348 loops=5)

  • Buffers: shared hit=3992899 read=1
4. 13.225 2,267.701 ↑ 1.3 165,348 5

Append (cost=0.00..3,413,555.92 rows=208,300 width=24) (actual time=0.166..2,267.701 rows=165,348 loops=5)

  • Buffers: shared hit=3992899 read=1
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-calculato%'::text))
6. 58.695 58.695 ↑ 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=0.165..58.695 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-calculato%'::text))
  • Rows Removed by Filter: 258638
  • Buffers: shared hit=117347
7. 444.774 444.774 ↑ 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=0.154..444.774 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-calculato%'::text))
  • Rows Removed by Filter: 2047499
  • Buffers: shared hit=981048
8. 875.993 875.993 ↑ 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=0.207..875.993 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-calculato%'::text))
  • Rows Removed by Filter: 4071807
  • Buffers: shared hit=1923746
9. 780.838 780.838 ↑ 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=686.732..780.838 rows=18,981 loops=5)

  • Index Cond: ((location_path ~>=~ '/tax-calculato'::text) AND (location_path ~<~ '/tax-calculatp'::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-calculato%'::text)
  • Heap Fetches: 0
  • Buffers: shared hit=418033
10. 94.176 94.176 ↑ 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=0.989..94.176 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-calculato%'::text)
  • Rows Removed by Filter: 154467
  • Buffers: shared hit=552725 read=1
Planning time : 15.874 ms
Execution time : 2,554.101 ms