explain.depesz.com

PostgreSQL's explain analyze made readable

Result: okz

Settings
# exclusive inclusive rows x rows loops node
1. 6.807 639.505 ↑ 174.0 1 1

Hash Join (cost=30,363.89..30,929.99 rows=174 width=146) (actual time=632.699..639.505 rows=1 loops=1)

  • Hash Cond: ((row_number() OVER (?)) = ((avg((row_number() OVER (?))))::integer))
2. 31.877 388.549 ↓ 1.8 63,015 1

Sort (cost=14,921.45..15,008.28 rows=34,730 width=154) (actual time=383.485..388.549 rows=63,015 loops=1)

  • Sort Key: flows01.service DESC
  • Sort Method: quicksort Memory: 4875kB
3. 19.524 356.672 ↓ 1.8 63,015 1

WindowAgg (cost=11,694.36..12,302.13 rows=34,730 width=154) (actual time=330.090..356.672 rows=63,015 loops=1)

4. 79.387 337.148 ↓ 1.8 63,015 1

Sort (cost=11,694.36..11,781.18 rows=34,730 width=146) (actual time=330.081..337.148 rows=63,015 loops=1)

  • Sort Key: flows01.service
  • Sort Method: quicksort Memory: 4490kB
5. 18.068 257.761 ↓ 1.8 63,015 1

Append (cost=0.00..9,075.04 rows=34,730 width=146) (actual time=0.033..257.761 rows=63,015 loops=1)

6. 0.006 0.006 ↓ 0.0 0 1

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

  • Filter: (service IS NOT NULL)
7. 239.687 239.687 ↓ 1.8 63,015 1

Seq Scan on flows01_melanie_2019001 (cost=0.00..9,075.04 rows=34,729 width=146) (actual time=0.026..239.687 rows=63,015 loops=1)

  • Filter: (service IS NOT NULL)
  • Rows Removed by Filter: 43016
8. 0.004 244.149 ↑ 1.0 1 1

Hash (cost=15,442.43..15,442.43 rows=1 width=4) (actual time=244.149..244.149 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 7.154 244.145 ↑ 1.0 1 1

Aggregate (cost=15,442.40..15,442.42 rows=1 width=4) (actual time=244.144..244.145 rows=1 loops=1)

10. 31.602 236.991 ↓ 1.8 63,015 1

Sort (cost=14,921.45..15,008.28 rows=34,730 width=154) (actual time=231.656..236.991 rows=63,015 loops=1)

  • Sort Key: flows01_1.service DESC
  • Sort Method: quicksort Memory: 4875kB
11. 22.422 205.389 ↓ 1.8 63,015 1

WindowAgg (cost=11,694.36..12,302.13 rows=34,730 width=154) (actual time=172.383..205.389 rows=63,015 loops=1)

12. 66.980 182.967 ↓ 1.8 63,015 1

Sort (cost=11,694.36..11,781.18 rows=34,730 width=146) (actual time=172.358..182.967 rows=63,015 loops=1)

  • Sort Key: flows01_1.service
  • Sort Method: quicksort Memory: 4490kB
13. 9.495 115.987 ↓ 1.8 63,015 1

Append (cost=0.00..9,075.04 rows=34,730 width=146) (actual time=0.026..115.987 rows=63,015 loops=1)

14. 0.008 0.008 ↓ 0.0 0 1

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

  • Filter: (service IS NOT NULL)
15. 106.484 106.484 ↓ 1.8 63,015 1

Seq Scan on flows01_melanie_2019001 flows01_melanie_2019001_1 (cost=0.00..9,075.04 rows=34,729 width=146) (actual time=0.017..106.484 rows=63,015 loops=1)

  • Filter: (service IS NOT NULL)
  • Rows Removed by Filter: 43016