explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cWff

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

Sort (cost=123.88..124.04 rows=64 width=214) (actual rows= loops=)

  • Sort Key: fraud_investigation_request.date_created DESC
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=120.68..121.32 rows=64 width=214) (actual rows= loops=)

  • Group Key: fraud_investigation_request.date_created, fraud_investigation_request.date_modified, fraud_investigation_request.id, fraud_investigation_request.member_uuid, fraud_investigation_request.reviewed_by, fraud_investigation_request.reviewer_comment
3. 0.000 0.000 ↓ 0.0

Append (cost=24.54..119.72 rows=64 width=214) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=24.54..82.32 rows=1 width=75) (actual rows= loops=)

  • Merge Cond: (fraud_investigation_request.member_uuid = fraud_investigation.member_uuid)
  • Filter: ((fraud_investigation.id IS NULL) AND (fraud_investigation.deleted_at IS NULL))
5. 0.000 0.000 ↓ 0.0

Index Scan using ix_fraud_investigation_request_member_uuid on fraud_investigation_request (cost=0.15..52.32 rows=790 width=75) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=23.60..24.28 rows=270 width=28) (actual rows= loops=)

  • Sort Key: fraud_investigation.member_uuid
7. 0.000 0.000 ↓ 0.0

Seq Scan on fraud_investigation (cost=0.00..12.70 rows=270 width=28) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Merge Join (cost=20.45..36.76 rows=63 width=75) (actual rows= loops=)

  • Merge Cond: (fraud_investigation_request_1.member_uuid = fraud_investigation_1.member_uuid)
  • Join Filter: (fraud_investigation_request_1.date_created > fraud_investigation_1.date_created)
9. 0.000 0.000 ↓ 0.0

Index Scan using ix_fraud_investigation_request_member_uuid on fraud_investigation_request fraud_investigation_request_1 (cost=0.15..52.32 rows=790 width=75) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Sort (cost=19.81..20.24 rows=173 width=24) (actual rows= loops=)

  • Sort Key: fraud_investigation_1.member_uuid
11. 0.000 0.000 ↓ 0.0

Seq Scan on fraud_investigation fraud_investigation_1 (cost=0.00..13.38 rows=173 width=24) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND ((fraud_category)::text = 'NOT_FRAUDULENT'::text))