explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JGsR : Slow (60k records per client)

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.034 538.340 ↑ 1.0 100 1

Limit (cost=0.56..19,055.95 rows=100 width=8) (actual time=468.225..538.340 rows=100 loops=1)

  • Output: id_ticket
  • Buffers: shared hit=316,806 dirtied=31
2. 538.306 538.306 ↑ 576.2 100 1

Index Scan Backward using pk_tabtickets_idticket on tickets.tab_tickets tt (cost=0.56..10,979,143.19 rows=57,617 width=8) (actual time=468.222..538.306 rows=100 loops=1)

  • Output: id_ticket
  • Filter: ((tt.id_client = 1,123,622) AND (tt.id_ticket_phase = 1))
  • Rows Removed by Filter: 313,552
  • Buffers: shared hit=316,806 dirtied=31
Planning time : 3.444 ms
Execution time : 538.423 ms