explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVaG : Optimization for: plan #EuL1

Settings

Optimization path:

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

Limit (cost=0.56..17,007.34 rows=100 width=8) (actual time=876.045..1,160.385 rows=100 loops=1)

  • Output: id_ticket
  • Buffers: shared hit=327894
2. 1,160.367 1,160.367 ↑ 645.7 100 1

Index Scan Backward using pk_tabtickets_idticket on tickets.tab_tickets tt (cost=0.56..10,981,953.64 rows=64,574 width=8) (actual time=876.043..1,160.367 rows=100 loops=1)

  • Output: id_ticket
  • Filter: ((tt.id_client = 1445372) AND (tt.id_ticket_phase = 1))
  • Rows Removed by Filter: 323850
  • Buffers: shared hit=327894
Planning time : 0.518 ms
Execution time : 1,160.466 ms