explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kP7 : Optimization for: plan #wCCr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.324 6.340 ↑ 1.0 1 1

Aggregate (cost=2,897.65..2,897.66 rows=1 width=160) (actual time=6.340..6.340 rows=1 loops=1)

  • Buffers: shared hit=4597 read=55
  • I/O Timings: read=0.258
2. 5.016 5.016 ↓ 1.5 4,808 1

Index Scan using simon_test_1 on transactions (cost=0.11..2,885.10 rows=3,137 width=15) (actual time=0.072..5.016 rows=4,808 loops=1)

  • Index Cond: ((is_bunkered = false) AND (station_id = ANY ('{1,2,3,4,5,6,7,8,9,10,11}'::bigint[])) AND (owner_id = 1) AND (transaction_at >= '2019-01-11 00:00:00'::timestamp without time zone) AND (transaction_at <= '2019-01-11 23:59:00'::timestamp without time zone))
  • Filter: (NOT is_bunkered)
  • Buffers: shared hit=4597 read=55
  • I/O Timings: read=0.258