explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EuL1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.020 7.159 ↑ 1.0 100 1

Limit (cost=953.19..953.44 rows=100 width=8) (actual time=7.130..7.159 rows=100 loops=1)

  • Output: id_ticket
  • Buffers: shared hit=434
2. 0.272 7.139 ↑ 2.4 100 1

Sort (cost=953.19..953.78 rows=235 width=8) (actual time=7.127..7.139 rows=100 loops=1)

  • Output: id_ticket
  • Sort Key: tt.id_ticket DESC
  • Sort Method: top-N heapsort Memory: 30kB
  • Buffers: shared hit=434
3. 6.867 6.867 ↓ 1.8 427 1

Index Scan using ix_tabtickets_idclient on tickets.tab_tickets tt (cost=0.56..944.21 rows=235 width=8) (actual time=0.138..6.867 rows=427 loops=1)

  • Output: id_ticket
  • Index Cond: (tt.id_client = 1598601)
  • Filter: (tt.id_ticket_phase = 1)
  • Buffers: shared hit=431
Planning time : 4.093 ms
Execution time : 7.218 ms