explain.depesz.com

PostgreSQL's explain analyze made readable

Result: txAA

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 267,698.763 ↑ 200.0 1 1

Sort (cost=110,458.09..110,458.59 rows=200 width=536) (actual time=267,698.763..267,698.763 rows=1 loops=1)

  • Sort Key: inq.newtimestamp
  • Sort Method: quicksort Memory: 25kB
2. 0.569 267,698.677 ↑ 200.0 1 1

Subquery Scan on inq (cost=110,416.44..110,450.44 rows=200 width=536) (actual time=267,698.662..267,698.677 rows=1 loops=1)

3. 408.045 267,698.108 ↑ 200.0 1 1

HashAggregate (cost=110,416.44..110,427.44 rows=200 width=168) (actual time=267,698.094..267,698.108 rows=1 loops=1)

  • Group Key: (184271400 + ((((nvpageaggregatetable_11_2019_kohls."timestamp" + 1388534400) - 184271400) / 28800) * 28800))
4. 138.716 267,290.063 ↑ 1.1 114,986 1

Result (cost=0.00..101,226.42 rows=131,286 width=168) (actual time=497.724..267,290.063 rows=114,986 loops=1)

5. 24.173 267,151.347 ↑ 1.1 114,986 1

Append (cost=0.00..99,585.35 rows=131,286 width=168) (actual time=497.707..267,151.347 rows=114,986 loops=1)

6. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 184271400) AND ("timestamp" <= 184278600))
7. 267,127.173 267,127.173 ↑ 1.1 114,986 1

Index Scan using nvpageaggregatetable_20191103080000_kohls_timestamp_idx on nvpageaggregatetable_20191103080000_kohls (cost=0.43..99,585.35 rows=131,285 width=168) (actual time=497.705..267,127.173 rows=114,986 loops=1)

  • Index Cond: (("timestamp" >= 184271400) AND ("timestamp" <= 184278600))
Planning time : 2,030.005 ms
Execution time : 267,699.557 ms