explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3aon

Settings
# exclusive inclusive rows x rows loops node
1. 2.130 9,386.210 ↓ 2.3 478 1

Hash Join (cost=90,373.56..90,396.88 rows=207 width=472) (actual time=9,382.882..9,386.210 rows=478 loops=1)

  • Hash Cond: (nvresourceaggregatetable_11_2019_kohls.domainid = b.domainid)
2. 399.220 9,371.868 ↓ 2.4 474 1

HashAggregate (cost=89,688.57..89,697.57 rows=200 width=60) (actual time=9,370.294..9,371.868 rows=474 loops=1)

  • Group Key: nvresourceaggregatetable_11_2019_kohls.domainid
3. 16.953 8,972.648 ↑ 1.0 146,668 1

Append (cost=0.00..76,243.83 rows=149,386 width=60) (actual time=6,544.312..8,972.648 rows=146,668 loops=1)

4. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 184305800) AND ("timestamp" <= 184309400))
5. 2,573.233 8,955.573 ↑ 1.0 146,668 1

Bitmap Heap Scan on nvresourceaggregatetable_20191103160000_kohls (cost=3,603.61..76,235.37 rows=149,384 width=60) (actual time=6,544.301..8,955.573 rows=146,668 loops=1)

  • Recheck Cond: (("timestamp" >= 184305800) AND ("timestamp" <= 184309400))
  • Heap Blocks: exact=5439
6. 6,382.340 6,382.340 ↑ 1.0 146,668 1

Bitmap Index Scan on nvresourceaggregatetable_20191103160000_kohls_timestamp_idx (cost=0.00..3,566.27 rows=149,384 width=0) (actual time=6,382.340..6,382.340 rows=146,668 loops=1)

  • Index Cond: (("timestamp" >= 184305800) AND ("timestamp" <= 184309400))
7. 0.009 0.122 ↓ 0.0 0 1

Bitmap Heap Scan on nvresourceaggregatetable_20191109160000_kohls (cost=4.44..8.46 rows=1 width=60) (actual time=0.122..0.122 rows=0 loops=1)

  • Recheck Cond: (("timestamp" >= 184305800) AND ("timestamp" <= 184309400))
8. 0.113 0.113 ↓ 0.0 0 1

Bitmap Index Scan on nvresourceaggregatetable_20191109160000_kohls_timestamp_idx (cost=0.00..4.44 rows=1 width=0) (actual time=0.113..0.113 rows=0 loops=1)

  • Index Cond: (("timestamp" >= 184305800) AND ("timestamp" <= 184309400))
9. 6.980 12.212 ↑ 1.0 22,001 1

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

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

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

Planning time : 28.463 ms
Execution time : 9,387.011 ms