explain.depesz.com

PostgreSQL's explain analyze made readable

Result: czf1

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

GroupAggregate (cost=0.43..687.81 rows=311 width=200) (actual rows= loops=)

  • Group Key: "paymentPlanId
2. 0.000 0.000 ↓ 0.0

Index Scan using ix_scheduled_payments_paymentplanid on "scheduledPayments" (cost=0.43..664.42 rows=312 width=32) (actual rows= loops=)

  • Index Cond: ("paymentPlanId" = ANY ('{75565,73681,74033,83546,74098,66932,64988,67763,68351,74468,74582,80245,70869,71724,71913,72064,80442,84149,81074,84483,87657,85276,75637,87692,89900}'::integer[]))