explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wCCr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.387 6.410 ↑ 1.0 1 1

Aggregate (cost=6,072.63..6,072.64 rows=1 width=160) (actual time=6.410..6.410 rows=1 loops=1)

  • Buffers: shared hit=1925
2. 4.349 5.023 ↓ 1.5 4,808 1

Bitmap Heap Scan on transactions (cost=54.83..6,060.08 rows=3,137 width=15) (actual time=0.917..5.023 rows=4,808 loops=1)

  • Recheck Cond: ((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) AND (margin_per_sale IS NOT NULL) AND ((NOT void) OR (void IS NULL)))
  • Filter: (NOT is_bunkered)
  • Heap Blocks: exact=1858
  • Buffers: shared hit=1925
3. 0.674 0.674 ↓ 1.5 4,808 1

Bitmap Index Scan on simon_test_1 (cost=0.00..54.67 rows=3,148 width=0) (actual time=0.674..0.674 rows=4,808 loops=1)

  • Index Cond: ((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))
  • Buffers: shared hit=67