explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ikx

Settings
# exclusive inclusive rows x rows loops node
1. 1,300.409 1,196,215.460 ↓ 1,174.5 272,474 1

Sort (cost=885,830.15..885,830.73 rows=232 width=1,025) (actual time=1,196,017.170..1,196,215.460 rows=272,474 loops=1)

  • Sort Key: (sum((nvresourceaggregatetable_kohls.duration_count)::bigint)) DESC
  • Sort Method: quicksort Memory: 106415kB
2. 2,382.645 1,194,915.051 ↓ 1,174.5 272,474 1

Nested Loop (cost=553,402.52..885,821.04 rows=232 width=1,025) (actual time=68,288.324..1,194,915.051 rows=272,474 loops=1)

  • Join Filter: (nvresourceaggregatetable_kohls.domainid = b.domainid)
3. 486.483 1,190,897.766 ↓ 1,216.2 272,440 1

Nested Loop (cost=553,402.24..885,733.67 rows=224 width=1,009) (actual time=68,288.041..1,190,897.766 rows=272,440 loops=1)

4. 12,699.329 74,381.637 ↓ 6.8 271,342 1

HashAggregate (cost=553,401.67..556,601.67 rows=40,000 width=120) (actual time=68,272.520..74,381.637 rows=271,342 loops=1)

  • Group Key: nvresourceaggregatetable_kohls.domainid, nvresourceaggregatetable_kohls.resourceid
5. 29,527.376 61,682.308 ↓ 1.0 557,423 1

Append (cost=0.00..454,353.25 rows=550,269 width=120) (actual time=6,072.510..61,682.308 rows=557,423 loops=1)

6. 0.002 0.002 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 187254000) AND ("timestamp" < 187336800) AND (pageid = 1))
7. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 187254000) AND ("timestamp" < 187336800) AND (pageid = 1))
8. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: (("timestamp" >= 187254000) AND ("timestamp" < 187336800) AND (pageid = 1))
9. 0.000 12,634.526 ↓ 1.1 75,622 1

Bitmap Heap Scan on nvresourceaggregatetable_20191208000000_kohls (cost=1,928.29..70,553.97 rows=71,486 width=120) (actual time=6,072.502..12,634.526 rows=75,622 loops=1)

  • Recheck Cond: (pageid = 1)
  • Filter: (("timestamp" >= 187254000) AND ("timestamp" < 187336800))
  • Rows Removed by Filter: 12919
  • Heap Blocks: exact=9651...skipping...ctual time=13596.214..29430.487 rows=239342 loops=1)
  • Recheck Cond: (pageid = 1)
  • Filter: (("timestamp" >= 187254000) AND ("timestamp" < 187336800))
  • Heap Blocks: exact=31014
10. 13,505.885 13,505.885 ↓ 1.0 239,342 1

Bitmap Index Scan on nvresourceaggregatetable_20191208080000_kohls_pageid_idx (cost=0.00..4,964.49 rows=232,008 width=0) (actual time=13,505.885..13,505.885 rows=239,342 loops=1)

  • Index Cond: (pageid = 1)
11. 9,408.639 19,520.403 ↑ 1.0 242,459 1

Bitmap Heap Scan on nvresourceaggregatetable_20191208160000_kohls (cost=5,340.92..201,913.92 rows=246,772 width=120) (actual time=10,168.922..19,520.403 rows=242,459 loops=1)

  • Recheck Cond: (pageid = 1)
  • Filter: (("timestamp" >= 187254000) AND ("timestamp" < 187336800))
  • Heap Blocks: exact=31646
12. 10,111.764 10,111.764 ↑ 1.0 242,459 1

Bitmap Index Scan on nvresourceaggregatetable_20191208160000_kohls_pageid_idx (cost=0.00..5,279.22 rows=246,772 width=0) (actual time=10,111.764..10,111.764 rows=242,459 loops=1)

  • Index Cond: (pageid = 1)
13. 1,116,029.646 1,116,029.646 ↑ 1.0 1 271,342

Index Scan using domresaggindex_kohls on nvaggregateresourcemetadatatable_kohls a (cost=0.56..8.21 rows=1 width=109) (actual time=4.065..4.113 rows=1 loops=271,342)

  • Index Cond: ((domainid = nvresourceaggregatetable_kohls.domainid) AND (resourceid = nvresourceaggregatetable_kohls.resourceid))
14. 1,634.640 1,634.640 ↑ 1.0 1 272,440

Index Scan using domainidagg_kohls on nvaggregatedomainmetadatatable_kohls b (cost=0.29..0.31 rows=1 width=24) (actual time=0.005..0.006 rows=1 loops=272,440)

  • Index Cond: (domainid = a.domainid)
Planning time : 405.559 ms
Execution time : 1,196,249.587 ms