explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3guX

Settings
# exclusive inclusive rows x rows loops node
1. 46.605 452,254.161 ↓ 328.1 15,420 1

Sort (cost=156,545.97..156,546.09 rows=47 width=1,025) (actual time=452,250.904..452,254.161 rows=15,420 loops=1)

  • Sort Key: (sum((nvresourceaggregatetable_11_2019_kohls.duration_count)::bigint)) DESC
  • Sort Method: quicksort Memory: 5688kB
2. 115.392 452,207.556 ↓ 328.1 15,420 1

Nested Loop (cost=87,214.95..156,544.66 rows=47 width=1,025) (actual time=431,608.596..452,207.556 rows=15,420 loops=1)

  • Join Filter: (nvresourceaggregatetable_11_2019_kohls.domainid = b.domainid)
3. 23.318 452,030.500 ↓ 342.6 15,416 1

Nested Loop (cost=87,214.66..156,527.09 rows=45 width=1,009) (actual time=431,608.019..452,030.500 rows=15,416 loops=1)

4. 1,210.031 431,765.062 ↓ 1.9 15,452 1

HashAggregate (cost=87,214.10..87,858.42 rows=8,054 width=120) (actual time=431,575.766..431,765.062 rows=15,452 loops=1)

  • Group Key: nvresourceaggregatetable_11_2019_kohls.domainid, nvresourceaggregatetable_11_2019_kohls.resourceid
5. 21.233 430,555.031 ↓ 1.0 81,415 1

Append (cost=0.00..72,717.26 rows=80,538 width=120) (actual time=230.157..430,555.031 rows=81,415 loops=1)

6. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 184876200) AND ("timestamp" < 184883400) AND (pageid = 1))
7. 0.053 0.053 ↓ 0.0 0 1

Index Scan using nvresourceaggregatetable_20191109160000_kohls_timestamp_idx on nvresourceaggregatetable_20191109160000_kohls (cost=0.43..8.45 rows=1 width=120) (actual time=0.053..0.053 rows=0 loops=1)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" < 184883400))
  • Filter: (pageid = 1)
8. 430,533.744 430,533.744 ↓ 1.0 81,415 1

Index Scan using nvresourceaggregatetable_20191110080000_kohls_timestamp_idx on nvresourceaggregatetable_20191110080000_kohls (cost=0.43..72,708.80 rows=80,536 width=120) (actual time=230.101..430,533.744 rows=81,415 loops=1)

  • Index Cond: (("timestamp" >= 184876200) AND ("timestamp" < 184883400))
  • Filter: (pageid = 1)
  • Rows Removed by Filter: 874247
9. 20,242.120 20,242.120 ↑ 1.0 1 15,452

Index Scan using domresaggindex_kohls on nvaggregateresourcemetadatatable_kohls a (cost=0.56..8.51 rows=1 width=109) (actual time=1.308..1.310 rows=1 loops=15,452)

  • Index Cond: ((domainid = nvresourceaggregatetable_11_2019_kohls.domainid) AND (resourceid = nvresourceaggregatetable_11_2019_kohls.resourceid))
10. 61.664 61.664 ↑ 1.0 1 15,416

Index Scan using domainidagg_kohls on nvaggregatedomainmetadatatable_kohls b (cost=0.29..0.31 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=15,416)

  • Index Cond: (domainid = a.domainid)
Planning time : 1,565.994 ms
Execution time : 452,261.336 ms