explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WSHg

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.095 ↓ 4.0 4 1

Limit (cost=18.30..18.30 rows=1 width=5,042) (actual time=0.090..0.095 rows=4 loops=1)

2. 0.010 0.090 ↓ 4.0 4 1

Sort (cost=18.30..18.30 rows=1 width=5,042) (actual time=0.088..0.090 rows=4 loops=1)

  • Sort Key: supplierin0_.id DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.008 0.080 ↓ 4.0 4 1

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

4. 0.010 0.056 ↓ 4.0 4 1

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

5. 0.011 0.042 ↓ 4.0 4 1

Nested Loop (cost=0.29..9.94 rows=1 width=342) (actual time=0.026..0.042 rows=4 loops=1)

6. 0.011 0.011 ↓ 4.0 4 1

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

  • Filter: (auction_id = 126352)
  • Rows Removed by Filter: 54
7. 0.020 0.020 ↑ 1.0 1 4

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

  • Index Cond: (id = auctions3_.invoice_id)
8. 0.004 0.004 ↓ 0.0 0 4

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

  • Index Cond: (supplierin0_.paymentadvice_id = id)
9. 0.016 0.016 ↑ 1.0 1 4

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

  • Index Cond: (id = 126352)
  • Heap Fetches: 4
Planning time : 0.467 ms
Execution time : 0.146 ms