explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sbgw

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 109,044.495 ↑ 1.0 101 1

Limit (cost=11,319,571.35..11,337,588.41 rows=101 width=585) (actual time=108,415.255..109,044.495 rows=101 loops=1)

  • Buffers: shared hit=121373 read=2917854 dirtied=2 written=4957, temp read=8688 written=147276
2. 587.883 109,044.462 ↑ 209.4 101 1

Aggregate (cost=11,319,571.35..15,092,451.07 rows=21,150 width=585) (actual time=108,415.255..109,044.462 rows=101 loops=1)

  • Filter: (sum(CASE WHEN ((t.bet_status_causing_transaction <> 0) AND (t.bet_status_expiration_date > '2019-09-05 16:42:43'::timestamp without time zone)) THEN 1 ELSE 0 END) <> 0)
  • Buffers: shared hit=121373 read=2917854 dirtied=2 written=4957, temp read=8688 written=147276
3. 14,960.041 108,456.579 ↑ 147.1 78,284 1

Sort (cost=11,319,571.35..11,348,350.97 rows=11,511,848 width=118) (actual time=108,414.762..108,456.579 rows=78,284 loops=1)

  • Sort Key: t.is_live, t.market_id, t.location_id
  • Sort Method: external merge Disk: 1177904kB
  • Buffers: shared hit=121365 read=2917854 dirtied=2 written=4957, temp read=8688 written=147276
4. 87,430.843 93,496.538 ↑ 1.4 8,130,148 1

Bitmap Heap Scan on fact_bet_transactions t (cost=667,555.01..9,261,176.85 rows=11,511,848 width=118) (actual time=6,741.762..93,496.538 rows=8,130,148 loops=1)

  • Filter: (t.bet_status_expiration_date >= '2019-08-30 16:42:43.444'::timestamp without time zone)
  • Buffers: shared hit=121357 read=2917854 dirtied=2 written=4957
5. 6,065.695 6,065.695 ↑ 1.2 21,354,595 1

Bitmap Index Scan on idx_overall_status_last_change_time2 (cost=0..664,677.05 rows=26,152,448 width=0) (actual time=6,065.695..6,065.695 rows=21,354,595 loops=1)

  • Index Cond: ((t.overall_status_last_change_time >= '2019-08-01 00:00:00'::timestamp without time zone) AND (t.overall_status_last_change_time <= '2019-08-30 23:59:59.999'::timestamp without time zone))
  • Buffers: shared hit=81825