explain.depesz.com

PostgreSQL's explain analyze made readable

Result: unxL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Result (cost=3,748.56..3,748.57 rows=1 width=16) (actual rows= loops=)

2.          

Initplan (forResult)

3. 0.000 0.000 ↓ 0.0

Limit (cost=2.51..1,874.28 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Custom Scan (ConstraintAwareAppend) (cost=2.51..39,642,235.23 rows=21,179 width=8) (actual rows= loops=)

  • Hypertable: tickers
  • Chunks left after exclusion: 1
5. 0.000 0.000 ↓ 0.0

Merge Append (cost=2.51..39,642,235.23 rows=21,179 width=8) (actual rows= loops=)

  • Sort Key: _hyper_1_5_chunk.closing_price DESC
6. 0.000 0.000 ↓ 0.0

Index Scan Backward using _hyper_1_5_chunk_closing_price_idx on _hyper_1_5_chunk (cost=0.57..38,426,111.47 rows=21,173 width=8) (actual rows= loops=)

  • Index Cond: (closing_price IS NOT NULL)
  • Filter: (((symbol)::text = 'BTC'::text) AND ("time" > (now() - '1 mon'::interval)))
7. 0.000 0.000 ↓ 0.0

Limit (cost=2.51..1,874.28 rows=1 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Custom Scan (ConstraintAwareAppend) (cost=2.51..39,642,235.23 rows=21,179 width=8) (actual rows= loops=)

  • Hypertable: tickers
  • Chunks left after exclusion: 1
9. 0.000 0.000 ↓ 0.0

Merge Append (cost=2.51..39,642,235.23 rows=21,179 width=8) (actual rows= loops=)

  • Sort Key: _hyper_1_5_chunk_1.closing_price
10. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_5_chunk_closing_price_idx on _hyper_1_5_chunk _hyper_1_5_chunk_1 (cost=0.57..38,426,111.47 rows=21,173 width=8) (actual rows= loops=)

  • Index Cond: (closing_price IS NOT NULL)
  • Filter: (((symbol)::text = 'BTC'::text) AND ("time" > (now() - '1 mon'::interval)))