explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qqfzh

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

Limit (cost=18.30..18.30 rows=1 width=5,042) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=18.30..18.30 rows=1 width=5,042) (actual rows= loops=)

  • Sort Key: supplierin0_.id DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..18.29 rows=1 width=5,042) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..10.12 rows=1 width=5,050) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..9.94 rows=1 width=342) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on supplierinvoice_auctions auctions3_ (cost=0.00..1.64 rows=1 width=16) (actual rows= loops=)

  • Filter: (auction_id = 126352)
7. 0.000 0.000 ↓ 0.0

Index Scan using supplierinvoice_pkey on supplierinvoice supplierin0_ (cost=0.29..8.30 rows=1 width=334) (actual rows= loops=)

  • Index Cond: (id = auctions3_.invoice_id)
8. 0.000 0.000 ↓ 0.0

Index Scan using invoicepaymentadvice_pkey on invoicepaymentadvice invoicepay1_ (cost=0.14..0.16 rows=1 width=4,708) (actual rows= loops=)

  • Index Cond: (supplierin0_.paymentadvice_id = id)
9. 0.000 0.000 ↓ 0.0

Index Only Scan using capfloorauction_pkey on capfloorauction capfloorau4_ (cost=0.14..8.15 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = 126352)