explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 75z

Settings
# exclusive inclusive rows x rows loops node
1. 322,852.583 1,611,739.551 ↓ 3.5 710 1

GroupAggregate (cost=58.70..25,255,728.55 rows=200 width=12) (actual time=5,372.987..1,611,739.551 rows=710 loops=1)

  • Output: holdings_detail.date_, count(DISTINCT holdings_detail.ticker)
  • Group Key: holdings_detail.date_
  • Buffers: shared hit=3709970 read=4409280
2. 1,249,923.357 1,288,886.968 ↑ 1.0 296,120,421 1

Merge Append (cost=58.70..23,775,124.44 rows=296,120,422 width=10) (actual time=2,980.570..1,288,886.968 rows=296,120,421 loops=1)

  • Sort Key: holdings_detail.date_ DESC
  • Buffers: shared hit=3709970 read=4409280
3. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using "DetailDate" on hk.holdings_detail (cost=0.12..8.14 rows=1 width=28) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: holdings_detail.date_, holdings_detail.ticker
  • Buffers: shared hit=1
4. 7,662.785 7,662.785 ↑ 1.0 1,774,186 1

Index Scan Backward using "_hyper_304_4641_chunk_DetailDate" on _timescaledb_internal._hyper_304_4641_chunk (cost=0.43..71,476.22 rows=1,774,186 width=10) (actual time=83.651..7,662.785 rows=1,774,186 loops=1)

  • Output: _hyper_304_4641_chunk.date_, _hyper_304_4641_chunk.ticker
  • Buffers: shared hit=22177 read=26373
5. 11,079.757 11,079.757 ↑ 1.0 2,638,956 1

Index Scan Backward using "_hyper_304_4763_chunk_DetailDate" on _timescaledb_internal._hyper_304_4763_chunk (cost=0.43..106,522.77 rows=2,638,956 width=10) (actual time=16.927..11,079.757 rows=2,638,956 loops=1)

  • Output: _hyper_304_4763_chunk.date_, _hyper_304_4763_chunk.ticker
  • Buffers: shared hit=33187 read=39245
6. 9,517.214 9,517.214 ↑ 1.0 2,194,230 1

Index Scan Backward using "_hyper_304_4764_chunk_DetailDate" on _timescaledb_internal._hyper_304_4764_chunk (cost=0.43..88,679.88 rows=2,194,230 width=10) (actual time=15.900..9,517.214 rows=2,194,230 loops=1)

  • Output: _hyper_304_4764_chunk.date_, _hyper_304_4764_chunk.ticker
  • Buffers: shared hit=27678 read=32654
7. 7,274.701 7,274.701 ↑ 1.0 1,751,754 1

Index Scan Backward using "_hyper_304_4765_chunk_DetailDate" on _timescaledb_internal._hyper_304_4765_chunk (cost=0.43..70,920.74 rows=1,751,754 width=10) (actual time=53.756..7,274.701 rows=1,751,754 loops=1)

  • Output: _hyper_304_4765_chunk.date_, _hyper_304_4765_chunk.ticker
  • Buffers: shared hit=22117 read=26045
8. 3,429.150 3,429.150 ↑ 1.0 878,355 1

Index Scan Backward using "_hyper_304_4766_chunk_DetailDate" on _timescaledb_internal._hyper_304_4766_chunk (cost=0.42..35,448.75 rows=878,355 width=10) (actual time=21.626..3,429.150 rows=878,355 loops=1)

  • Output: _hyper_304_4766_chunk.date_, _hyper_304_4766_chunk.ticker
  • Buffers: shared hit=11057 read=13036