explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AXnw : Req8 # o

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 256.453 ↑ 1.1 9 1

Limit (cost=17,310.14..17,310.24 rows=10 width=144) (actual time=256.430..256.453 rows=9 loops=1)

  • Buffers: shared hit=14525
2. 0.077 256.450 ↑ 918.1 9 1

HashAggregate (cost=17,310.14..17,392.77 rows=8,263 width=144) (actual time=256.428..256.450 rows=9 loops=1)

  • Group Key: tt_trouble_ticket.ticketid, tt_trouble_ticket.priorityid, tt_trouble_ticket.feuillet, tt_trouble_ticket.pilotgroupid, tt_trouble_ticket.id_priorite, tt_trouble_ticket.old_feuillet, tt_trouble_ticket.hierarchie, tt_trouble_ticket.serviceid1value, tt_trouble_ticket.serviceid2value, tt_trouble_ticket.serviceid3value, tt_trouble_ticket.calcul_infos, tt_trouble_ticket.servicechangeproduct, tt_trouble_ticket.old_serviceid1value, tt_trouble_ticket.horodatage_maj_ticket, tt_trouble_ticket.id_diag_res, tt_trouble_ticket.initgroupid
  • Buffers: shared hit=14525
3. 15.365 256.373 ↑ 918.1 9 1

Hash Join (cost=21.34..16,979.62 rows=8,263 width=144) (actual time=32.583..256.373 rows=9 loops=1)

  • Hash Cond: ((tt_trouble_ticket.pilotgroupid)::text = (iai_params_specifiques_eds.eds_params)::text)
  • Buffers: shared hit=14525
4. 240.832 240.832 ↓ 1.0 84,216 1

Seq Scan on tt_trouble_ticket (cost=0.00..16,564.69 rows=82,922 width=144) (actual time=0.021..240.832 rows=84,216 loops=1)

  • Filter: ((id_priorite IS NULL) AND ((currentstatus)::text = ANY ('{0,1,2,3,4}'::text[])))
  • Rows Removed by Filter: 42042
  • Buffers: shared hit=14513
5. 0.031 0.176 ↑ 1.0 57 1

Hash (cost=20.62..20.62 rows=58 width=7) (actual time=0.176..0.176 rows=57 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=12
6. 0.101 0.145 ↑ 1.0 57 1

Bitmap Heap Scan on iai_params_specifiques_eds (cost=4.73..20.62 rows=58 width=7) (actual time=0.061..0.145 rows=57 loops=1)

  • Recheck Cond: ((prio_automatique)::text = 'on'::text)
  • Filter: ((actif)::text = 'Actif'::text)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=10
  • Buffers: shared hit=12
7. 0.044 0.044 ↑ 1.0 59 1

Bitmap Index Scan on iai_params_specifiques_eds_prio_automatique (cost=0.00..4.72 rows=59 width=0) (actual time=0.044..0.044 rows=59 loops=1)

  • Index Cond: ((prio_automatique)::text = 'on'::text)
  • Buffers: shared hit=2