explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9LNl

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 45,120.340 ↑ 1.4 56 1

Sort (cost=688,327.63..688,327.84 rows=81 width=108) (actual time=45,120.335..45,120.340 rows=56 loops=1)

  • Sort Key: (sum(a.pagecount)) DESC
  • Sort Method: quicksort Memory: 32kB
2. 16,771.043 45,120.285 ↑ 1.4 56 1

HashAggregate (cost=688,309.68..688,325.07 rows=81 width=108) (actual time=45,119.664..45,120.285 rows=56 loops=1)

  • Group Key: b.pagename
3. 1,092.024 28,349.242 ↓ 2.5 2,663,870 1

Hash Join (cost=2.82..496,534.59 rows=1,080,423 width=108) (actual time=3,237.103..28,349.242 rows=2,663,870 loops=1)

  • Hash Cond: (a.pageid = b.pageid)
4. 320.761 27,255.416 ↑ 1.0 2,663,870 1

Append (cost=0.00..475,723.62 rows=2,667,712 width=100) (actual time=3,235.117..27,255.416 rows=2,663,870 loops=1)

5. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nvpageaggregatetable_11_2019_kohls a (cost=0.00..0.00 rows=1 width=100) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (("timestamp" >= 186604200) AND ("timestamp" < 186690600))
6. 9,794.075 9,794.075 ↓ 1.0 869,528 1

Seq Scan on nvpageaggregatetable_20191130080000_kohls a_1 (cost=0.00..236,651.54 rows=868,372 width=100) (actual time=3,235.113..9,794.075 rows=869,528 loops=1)

  • Filter: (("timestamp" >= 186604200) AND ("timestamp" < 186690600))
  • Rows Removed by Filter: 1084854
7. 17,140.579 17,140.579 ↑ 1.0 1,794,342 1

Seq Scan on nvpageaggregatetable_20191130160000_kohls a_2 (cost=0.00..239,072.08 rows=1,799,339 width=100) (actual time=44.287..17,140.579 rows=1,794,342 loops=1)

  • Filter: (("timestamp" >= 186604200) AND ("timestamp" < 186690600))
8. 0.073 1.802 ↓ 1.0 85 1

Hash (cost=1.81..1.81 rows=81 width=14) (actual time=1.802..1.802 rows=85 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
9. 1.729 1.729 ↓ 1.0 85 1

Seq Scan on nvpagemetadatatable_kohls b (cost=0.00..1.81 rows=81 width=14) (actual time=1.704..1.729 rows=85 loops=1)

Planning time : 1,268.855 ms
Execution time : 45,120.924 ms