explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WkCq

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

Index Scan using idx_trans_paymentdate on transactions this_ (cost=0.45..7,187.59 rows=1 width=2,782) (actual rows= loops=)

  • Index Cond: (payment_date > (('now'::cstring)::date - '24:00:00'::interval))
  • Filter: (is_using_optional = 0)