explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 91r0

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.072 ↑ 1.0 1 1

Limit (cost=12.18..12.18 rows=1 width=1,238) (actual time=0.071..0.072 rows=1 loops=1)

2. 0.027 0.070 ↑ 3.0 1 1

Sort (cost=12.18..12.19 rows=3 width=1,238) (actual time=0.070..0.070 rows=1 loops=1)

  • Sort Key: created_at DESC
  • Sort Method: quicksort Memory: 27kB
3. 0.043 0.043 ↑ 3.0 1 1

Index Scan using index_payment_transactions_on_transaction_origin_id_and_type on payment_transactions (cost=0.42..12.17 rows=3 width=1,238) (actual time=0.043..0.043 rows=1 loops=1)

  • Index Cond: ((transaction_origin_id = 597160) AND ((transaction_origin_type)::text = 'Invoice'::text))