explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 31l8 : symon

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 501.701 2,575.842 ↓ 11.4 96,570 1

HashAggregate (cost=85,661.42..85,767.40 rows=8,478 width=25) (actual time=2,408.503..2,575.842 rows=96,570 loops=1)

  • Group Key: terminal_id, cash_status_timestamp
2. 2,074.141 2,074.141 ↓ 1.1 96,570 1

Index Scan using channels_cash_status_timestamp_idx on channels (cost=0.56..84,601.75 rows=84,774 width=25) (actual time=0.711..2,074.141 rows=96,570 loops=1)

  • Index Cond: ((cash_status_timestamp >= '2019-04-01 00:00:00'::timestamp without time zone) AND (cash_status_timestamp <= '2019-04-02 00:10:00'::timestamp without time zone))
  • Filter: ((cash_status)::text = 'OUT OF CASH'::text)
  • Rows Removed by Filter: 773425