explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Roje : Fast (500 records per client)

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.018 1.597 ↑ 1.0 100 1

Limit (cost=957.31..957.56 rows=100 width=8) (actual time=1.569..1.597 rows=100 loops=1)

  • Output: id_ticket
  • Buffers: shared hit=431
2. 0.186 1.579 ↑ 2.4 100 1

Sort (cost=957.31..957.90 rows=236 width=8) (actual time=1.567..1.579 rows=100 loops=1)

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

Index Scan using ix_tabtickets_idclient on tickets.tab_tickets tt (cost=0.56..948.29 rows=236 width=8) (actual time=0.058..1.393 rows=427 loops=1)

  • Output: id_ticket
  • Index Cond: (tt.id_client = 1,598,601)
  • Filter: (tt.id_ticket_phase = 1)
  • Buffers: shared hit=431
Planning time : 0.614 ms
Execution time : 1.671 ms