explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vY7

Settings
# exclusive inclusive rows x rows loops node
1. 8.186 266.875 ↑ 1.0 1 1

Aggregate (cost=40,469.41..40,469.42 rows=1 width=48) (actual time=266.872..266.875 rows=1 loops=1)

  • Buffers: shared hit=21,256
2. 13.987 258.689 ↓ 267.2 13,358 1

Subquery Scan on length_of_session (cost=36,742.13..40,468.65 rows=50 width=33) (actual time=167.353..258.689 rows=13,358 loops=1)

  • Filter: (length_of_session.is_end_of_session AND (length_of_session.length_of_session >= '00:00:10'::interval) AND (length_of_session.length_of_session <= '01:00:00'::interval))
  • Rows Removed by Filter: 80,432
  • Buffers: shared hit=21,256
3. 69.024 244.702 ↑ 1.1 93,790 1

WindowAgg (cost=36,742.13..38,871.57 rows=106,472 width=34) (actual time=167.321..244.702 rows=93,790 loops=1)

  • Buffers: shared hit=21,256
4. 33.940 175.678 ↑ 1.1 93,790 1

Sort (cost=36,742.13..37,008.31 rows=106,472 width=25) (actual time=167.312..175.678 rows=93,790 loops=1)

  • Sort Key: start_end_session.remote_address_hash
  • Sort Method: quicksort Memory: 10,277kB
  • Buffers: shared hit=21,256
5. 141.738 141.738 ↑ 1.1 93,790 1

Seq Scan on start_end_session (cost=0.00..27,851.66 rows=106,472 width=25) (actual time=0.014..141.738 rows=93,790 loops=1)

  • Filter: ((is_start_of_session AND (NOT is_end_of_session)) OR ((NOT is_start_of_session) AND is_end_of_session))
  • Rows Removed by Filter: 565,776
  • Buffers: shared hit=21,256
Planning time : 0.185 ms
Execution time : 267.447 ms