explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xrOy : Optimization for: plan #gVzb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 260.021 3,652.188 ↓ 45.7 48,958 1

WindowAgg (cost=0.56..259,249.57 rows=1,071 width=19) (actual time=6.594..3,652.188 rows=48,958 loops=1)

2. 3,392.167 3,392.167 ↓ 45.7 48,958 1

Index Only Scan using test_index on bmx_sw_mm_metas (cost=0.56..259,228.15 rows=1,071 width=15) (actual time=6.588..3,392.167 rows=48,958 loops=1)

  • Index Cond: ("timestamp" > 1560167490)
  • Filter: ((symbol)::text <> ALL ('{eth_usdt,btc_usdt}'::text[]))
  • Heap Fetches: 48958
Planning time : 0.131 ms
Execution time : 3,694.414 ms