explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pJwQ : Optimization for: plan #3PpG

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.015 207.228 ↑ 1.0 100 1

Limit (cost=172,295.42..172,295.67 rows=100 width=16) (actual time=207.203..207.228 rows=100 loops=1)

2. 12.477 207.213 ↑ 447.6 100 1

Sort (cost=172,295.42..172,407.33 rows=44,765 width=16) (actual time=207.202..207.213 rows=100 loops=1)

  • Sort Key: (GREATEST(ticket_time_bet, ticket_time_evaluation, ticket_time_cash)) DESC
  • Sort Method: top-N heapsort Memory: 32kB
3. 179.813 194.736 ↓ 1.1 49,025 1

Bitmap Heap Scan on tab_tickets tt (cost=1,180.56..170,584.53 rows=44,765 width=16) (actual time=25.915..194.736 rows=49,025 loops=1)

  • Recheck Cond: (id_client = 1035287)
  • Filter: ((id_ticket_state = ANY ('{5,6}'::integer[])) AND (id_ticket_phase = 1))
  • Heap Blocks: exact=46729
4. 14.923 14.923 ↓ 1.0 49,130 1

Bitmap Index Scan on ix_tabtickets_idclient_betdate (cost=0.00..1,169.37 rows=47,040 width=0) (actual time=14.923..14.923 rows=49,130 loops=1)

  • Index Cond: (id_client = 1035287)
Planning time : 0.621 ms
Execution time : 207.289 ms