explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4WLh

Settings
# exclusive inclusive rows x rows loops node
1. 173.259 677.798 ↓ 16.8 3,355 1

HashAggregate (cost=30,691.13..30,693.13 rows=200 width=12) (actual time=677.328..677.798 rows=3,355 loops=1)

  • Group Key: accounting_tab.username
2. 224.155 504.539 ↓ 1.2 648,606 1

Custom Scan (ChunkAppend) on accounting_tab (cost=0.43..28,047.45 rows=528,735 width=12) (actual time=0.024..504.539 rows=648,606 loops=1)

  • Chunks excluded during startup: 27
  • -> Index Scan using _hyper_1_106_chunk_accounting_nastimestamp_idx on _hyper_1_106_chunk (cost=0.43..9046.23 rows=165101 width=12) (actual time=0.023..173.928 r
  • Index Cond: (nastimestamp > (now() - '3 days'::interval))
3. 280.384 280.384 ↓ 1.0 363,638 1

Seq Scan on _hyper_1_108_chunk (cost=0.00..18,852.12 rows=363,607 width=12) (actual time=0.021..280.384 rows=363,638 loops=1)

  • Filter: (nastimestamp > (now() - '3 days'::interval))