explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ikxf

Settings
# exclusive inclusive rows x rows loops node
1. 0.531 33.203 ↑ 18.0 1 1

Hash Join (cost=2,924.00..2,982.92 rows=18 width=146) (actual time=32.659..33.203 rows=1 loops=1)

  • Hash Cond: ((row_number() OVER (?)) = ((avg((row_number() OVER (?))))::integer))
  • Buffers: shared hit=1816
2. 2.913 18.731 ↑ 1.2 2,962 1

Sort (cost=1,434.87..1,443.91 rows=3,615 width=154) (actual time=18.314..18.731 rows=2,962 loops=1)

  • Sort Key: flows01.service DESC
  • Sort Method: quicksort Memory: 315kB
  • Buffers: shared hit=908
3. 2.681 15.818 ↑ 1.2 2,962 1

WindowAgg (cost=1,157.96..1,221.23 rows=3,615 width=154) (actual time=12.241..15.818 rows=2,962 loops=1)

  • Buffers: shared hit=908
4. 3.260 13.137 ↑ 1.2 2,962 1

Sort (cost=1,157.96..1,167.00 rows=3,615 width=146) (actual time=12.229..13.137 rows=2,962 loops=1)

  • Sort Key: flows01.service
  • Sort Method: quicksort Memory: 235kB
  • Buffers: shared hit=908
5. 0.755 9.877 ↑ 1.2 2,962 1

Append (cost=0.00..944.32 rows=3,615 width=146) (actual time=0.062..9.877 rows=2,962 loops=1)

  • Buffers: shared hit=908
6. 0.041 0.041 ↓ 0.0 0 1

Seq Scan on flows01 (cost=0.00..0.00 rows=1 width=146) (actual time=0.041..0.041 rows=0 loops=1)

  • Filter: (service IS NOT NULL)
7. 8.348 8.348 ↑ 1.2 2,726 1

Seq Scan on flows01_janonym_2019001 (cost=0.00..871.52 rows=3,335 width=146) (actual time=0.020..8.348 rows=2,726 loops=1)

  • Filter: (service IS NOT NULL)
  • Rows Removed by Filter: 11245
  • Buffers: shared hit=838
8. 0.733 0.733 ↑ 1.2 236 1

Seq Scan on flows01_janonym_2019002 (cost=0.00..72.80 rows=279 width=146) (actual time=0.031..0.733 rows=236 loops=1)

  • Filter: (service IS NOT NULL)
  • Rows Removed by Filter: 1009
  • Buffers: shared hit=70
9. 0.004 13.941 ↑ 1.0 1 1

Hash (cost=1,489.12..1,489.12 rows=1 width=4) (actual time=13.941..13.941 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=908
10. 0.455 13.937 ↑ 1.0 1 1

Aggregate (cost=1,489.10..1,489.11 rows=1 width=4) (actual time=13.936..13.937 rows=1 loops=1)

  • Buffers: shared hit=908
11. 1.549 13.482 ↑ 1.2 2,962 1

Sort (cost=1,434.87..1,443.91 rows=3,615 width=154) (actual time=13.126..13.482 rows=2,962 loops=1)

  • Sort Key: flows01_1.service DESC
  • Sort Method: quicksort Memory: 315kB
  • Buffers: shared hit=908
12. 1.537 11.933 ↑ 1.2 2,962 1

WindowAgg (cost=1,157.96..1,221.23 rows=3,615 width=154) (actual time=9.892..11.933 rows=2,962 loops=1)

  • Buffers: shared hit=908
13. 2.323 10.396 ↑ 1.2 2,962 1

Sort (cost=1,157.96..1,167.00 rows=3,615 width=146) (actual time=9.882..10.396 rows=2,962 loops=1)

  • Sort Key: flows01_1.service
  • Sort Method: quicksort Memory: 235kB
  • Buffers: shared hit=908
14. 0.716 8.073 ↑ 1.2 2,962 1

Append (cost=0.00..944.32 rows=3,615 width=146) (actual time=0.044..8.073 rows=2,962 loops=1)

  • Buffers: shared hit=908
15. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on flows01 flows01_1 (cost=0.00..0.00 rows=1 width=146) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (service IS NOT NULL)
16. 6.867 6.867 ↑ 1.2 2,726 1

Seq Scan on flows01_janonym_2019001 flows01_janonym_2019001_1 (cost=0.00..871.52 rows=3,335 width=146) (actual time=0.027..6.867 rows=2,726 loops=1)

  • Filter: (service IS NOT NULL)
  • Rows Removed by Filter: 11245
  • Buffers: shared hit=838
17. 0.477 0.477 ↑ 1.2 236 1

Seq Scan on flows01_janonym_2019002 flows01_janonym_2019002_1 (cost=0.00..72.80 rows=279 width=146) (actual time=0.026..0.477 rows=236 loops=1)

  • Filter: (service IS NOT NULL)
  • Rows Removed by Filter: 1009
  • Buffers: shared hit=70