explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SUO

Settings
# exclusive inclusive rows x rows loops node
1. 23.872 104,002.611 ↓ 314.7 12,904 1

Sort (cost=4,597,692.91..4,597,693.02 rows=41 width=1,025) (actual time=103,999.581..104,002.611 rows=12,904 loops=1)

  • Sort Key: inq.durationcount DESC
  • Sort Method: quicksort Memory: 4624kB
2. 55.949 103,978.739 ↓ 314.7 12,904 1

Hash Join (cost=3,602,351.54..4,597,691.82 rows=41 width=1,025) (actual time=62,607.695..103,978.739 rows=12,904 loops=1)

  • Hash Cond: (inq.domainid = b.domainid)
3. 42,146.666 103,907.437 ↓ 322.6 12,903 1

Hash Join (cost=3,601,666.54..4,597,002.94 rows=40 width=1,009) (actual time=62,591.906..103,907.437 rows=12,903 loops=1)

  • Hash Cond: ((inq.resourceid = a.resourceid) AND (inq.domainid = a.domainid))
4. 3.625 6,554.326 ↓ 1.8 12,907 1

Subquery Scan on inq (cost=318,249.84..318,888.84 rows=7,100 width=904) (actual time=6,475.789..6,554.326 rows=12,907 loops=1)

5. 518.504 6,550.701 ↓ 1.8 12,907 1

HashAggregate (cost=318,249.84..318,817.84 rows=7,100 width=120) (actual time=6,475.780..6,550.701 rows=12,907 loops=1)

  • Group Key: nvresourceaggregatetable_11_2019_kohls.domainid, nvresourceaggregatetable_11_2019_kohls.resourceid
6. 9.106 6,032.197 ↑ 1.0 70,315 1

Append (cost=0.00..305,470.74 rows=70,995 width=120) (actual time=4,095.281..6,032.197 rows=70,315 loops=1)

7. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 185049000) AND ("timestamp" < 185056200) AND (pageid = 1))
8. 722.144 722.144 ↓ 0.0 0 1

Seq Scan on nvresourceaggregatetable_20191109160000_kohls (cost=0.00..137,544.75 rows=1 width=120) (actual time=722.144..722.144 rows=0 loops=1)

  • Filter: (("timestamp" >= 185049000) AND ("timestamp" < 185056200) AND (pageid = 1))
  • Rows Removed by Filter: 2522038
9. 5,300.947 5,300.947 ↑ 1.0 70,315 1

Seq Scan on nvresourceaggregatetable_20191112080000_kohls (cost=0.00..167,925.99 rows=70,993 width=120) (actual time=3,373.131..5,300.947 rows=70,315 loops=1)

  • Filter: (("timestamp" >= 185049000) AND ("timestamp" < 185056200) AND (pageid = 1))
  • Rows Removed by Filter: 3008813
10. 40,096.296 55,206.445 ↓ 1.0 56,523,219 1

Hash (cost=1,518,872.28..1,518,872.28 rows=55,837,228 width=109) (actual time=55,206.445..55,206.445 rows=56,523,219 loops=1)

  • Buckets: 4194304 Batches: 16 Memory Usage: 516830kB
11. 15,110.149 15,110.149 ↓ 1.0 56,523,219 1

Seq Scan on nvaggregateresourcemetadatatable_kohls a (cost=0.00..1,518,872.28 rows=55,837,228 width=109) (actual time=0.067..15,110.149 rows=56,523,219 loops=1)

12. 8.110 15.353 ↑ 1.0 22,001 1

Hash (cost=402.22..402.22 rows=22,622 width=24) (actual time=15.353..15.353 rows=22,001 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1552kB
13. 7.243 7.243 ↑ 1.0 22,001 1

Seq Scan on nvaggregatedomainmetadatatable_kohls b (cost=0.00..402.22 rows=22,622 width=24) (actual time=0.013..7.243 rows=22,001 loops=1)

Planning time : 347.773 ms
Execution time : 104,028.663 ms