explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gVzb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 36.849 61,465.187 ↓ 44.4 48,355 1

WindowAgg (cost=452,341.76..452,366.24 rows=1,088 width=19) (actual time=61,414.353..61,465.187 rows=48,355 loops=1)

2. 115.018 61,428.338 ↓ 44.4 48,355 1

Sort (cost=452,341.76..452,344.48 rows=1,088 width=15) (actual time=61,414.339..61,428.338 rows=48,355 loops=1)

  • Sort Key: symbol, "timestamp
  • Sort Method: quicksort Memory: 3676kB
3. 45.288 61,313.320 ↓ 44.4 48,355 1

Gather (cost=1,000.00..452,286.88 rows=1,088 width=15) (actual time=48,084.405..61,313.320 rows=48,355 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 61,268.032 61,268.032 ↓ 35.6 16,118 3

Parallel Seq Scan on bmx_sw_mm_metas (cost=0.00..451,178.08 rows=453 width=15) (actual time=48,046.596..61,268.032 rows=16,118 loops=3)

  • Filter: (("timestamp" > 1560167490) AND ((symbol)::text <> ALL ('{eth_usdt,btc_usdt}'::text[])))
  • Rows Removed by Filter: 3612250
Planning time : 0.311 ms
Execution time : 61,474.810 ms