explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bUJo

Settings
# exclusive inclusive rows x rows loops node
1. 6.424 6,547.539 ↑ 1.0 1 1

Aggregate (cost=26,871.06..26,871.07 rows=1 width=112) (actual time=6,547.539..6,547.539 rows=1 loops=1)

  • Buffers: shared hit=1,817 read=19,895 dirtied=419
  • I/O Timings: read=6,380.969
2. 6,541.115 6,541.115 ↓ 3.3 22,268 1

Bitmap Heap Scan on transactions (cost=407.73..26,614.67 rows=6,837 width=36) (actual time=112.779..6,541.115 rows=22,268 loops=1)

  • Recheck Cond: ((organisation_id = 'm:b43e0d80-1c41-4a67-93c9-a0963318b9c5'::text) AND (transaction_ts_ms >= '1596204000000'::bigint) AND (tra
  • Filter: (gateway_resp_status = 1)
  • Heap Blocks: exact=21,397
  • Buffers: shared hit=1,817 read=19,895 dirtied=419
  • I/O Timings: read=6,380.969
  • -> Bitmap Index Scan on transactions_organisation_id_transaction_ts_ms_v2_idx (cost=0.00..406.02 rows=6,837 width=0) (actual time=109.640..1
  • Index Cond: ((organisation_id = 'm:b43e0d80-1c41-4a67-93c9-a0963318b9c5'::text) AND (transaction_ts_ms >= '1596204000000'::bigint) AND
  • Buffers: shared hit=2 read=313
  • I/O Timings: read=104.089
Planning time : 0.135 ms
Execution time : 6,547.687 ms