explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SKz1

Settings
# exclusive inclusive rows x rows loops node
1. 45.088 775.286 ↓ 3.3 83,068 1

WindowAgg (cost=3,166.50..3,737.93 rows=25,397 width=19) (actual time=713.811..775.286 rows=83,068 loops=1)

2. 654.051 730.198 ↓ 3.3 83,068 1

Sort (cost=3,166.50..3,229.99 rows=25,397 width=15) (actual time=713.785..730.198 rows=83,068 loops=1)

  • Sort Key: symbol, "timestamp
  • Sort Method: external merge Disk: 2144kB
3. 76.147 76.147 ↓ 3.3 83,068 1

Index Scan using bmx_sw_mm_metas_timestamp_idx on bmx_sw_mm_metas (cost=0.43..1,308.41 rows=25,397 width=15) (actual time=6.463..76.147 rows=83,068 loops=1)

  • Index Cond: ("timestamp" > 1560167490)
  • Filter: ((symbol)::text <> ALL ('{eth_usdt,btc_usdt}'::text[]))
Planning time : 20.609 ms
Execution time : 781.224 ms