explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xfjj

Settings
# exclusive inclusive rows x rows loops node
1. 1.250 593.163 ↓ 4.9 1,008 1

Nested Loop (cost=31,914.78..32,755.74 rows=207 width=472) (actual time=586.026..593.163 rows=1,008 loops=1)

2. 348.734 588.937 ↓ 5.0 992 1

HashAggregate (cost=31,914.49..31,923.49 rows=200 width=60) (actual time=585.891..588.937 rows=992 loops=1)

  • Group Key: nvresourceaggregatetable_11_2019_kohls.domainid
3. 16.984 240.203 ↑ 1.0 184,792 1

Append (cost=0.00..15,146.41 rows=186,312 width=60) (actual time=0.170..240.203 rows=184,792 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 184271400) AND ("timestamp" <= 184278600))
5. 223.165 223.165 ↑ 1.0 184,792 1

Index Scan using nvresourceaggregatetable_20191103080000_kohls_timestamp_idx on nvresourceaggregatetable_20191103080000_kohls (cost=0.43..15,137.96 rows=186,310 width=60) (actual time=0.168..223.165 rows=184,792 loops=1)

  • Index Cond: (("timestamp" >= 184271400) AND ("timestamp" <= 184278600))
6. 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=60) (actual time=0.053..0.053 rows=0 loops=1)

  • Index Cond: (("timestamp" >= 184271400) AND ("timestamp" <= 184278600))
7. 2.976 2.976 ↑ 1.0 1 992

Index Scan using domainidagg_kohls on nvaggregatedomainmetadatatable_kohls b (cost=0.29..4.10 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=992)

  • Index Cond: (domainid = nvresourceaggregatetable_11_2019_kohls.domainid)
Planning time : 29,688.592 ms
Execution time : 594.005 ms