explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rrN1

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 7,979.478 ↑ 1.0 10 1

Limit (cost=43,260.72..43,260.74 rows=10 width=9,139) (actual time=7,979.475..7,979.478 rows=10 loops=1)

2. 17.769 7,979.476 ↑ 45.8 10 1

Sort (cost=43,260.72..43,261.86 rows=458 width=9,139) (actual time=7,979.474..7,979.476 rows=10 loops=1)

  • Sort Key: t.modified_dt DESC
  • Sort Method: top-N heapsort Memory: 75kB
3. 9.717 7,961.707 ↓ 4.4 2,038 1

Nested Loop (cost=1.30..43,250.82 rows=458 width=9,139) (actual time=0.527..7,961.707 rows=2,038 loops=1)

4. 19.426 7,887.840 ↑ 1.3 6,415 1

Nested Loop (cost=0.88..29,121.52 rows=8,036 width=4,035) (actual time=0.510..7,887.840 rows=6,415 loops=1)

5. 2,659.434 2,659.434 ↑ 1.3 6,415 1

Index Scan using orders_order_2bfe9d72 on orders_order o (cost=0.44..8,672.24 rows=8,592 width=216) (actual time=0.030..2,659.434 rows=6,415 loops=1)

  • Index Cond: (client_id = 708255413)
6. 5,208.980 5,208.980 ↑ 1.0 1 6,415

Index Scan using idx_orderitem_order_id_sorted on orders_orderitem oi (cost=0.44..2.37 rows=1 width=3,819) (actual time=0.811..0.812 rows=1 loops=6,415)

  • Index Cond: (order_id = o.order_id)
7. 64.150 64.150 ↓ 0.0 0 6,415

Index Scan using idx_tickets_modified_dt2 on tickets_ticket t (cost=0.42..1.75 rows=1 width=5,096) (actual time=0.009..0.010 rows=0 loops=6,415)

  • Index Cond: (order_item_id = oi.order_item_id)