explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GEcr : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=116,658.97..116,661.47 rows=1,000 width=47) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=116,628.97..117,293.92 rows=265,979 width=47) (actual rows= loops=)

  • Sort Key: event_store_events_in_streams."position" DESC, event_store_events_in_streams.id DESC
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=68,678.20..97,124.43 rows=265,979 width=47) (actual rows= loops=)

  • Hash Cond: (event_store_events_in_streams.event_id = event_store_events.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on event_store_events_in_streams (cost=0.00..18,049.03 rows=265,979 width=47) (actual rows= loops=)

  • Filter: ((stream)::text = 'OrderRefund-0748011e57c708'::text)
5. 0.000 0.000 ↓ 0.0

Hash (cost=61,330.66..61,330.66 rows=422,683 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on event_store_events (cost=0.00..61,330.66 rows=422,683 width=16) (actual rows= loops=)

  • Filter: ((event_type)::text = ANY ('{OrderRefundRequested,OrderRefundFailed,OrderRefundCompleted,OrderCombinedRefundRetryableFailure,OrderCashRefundSucceeded,OrderCombinedRefundFailed,OrderCombinedRefundSucceeded,OrderRefundSucceeded}'::text[]))