explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FwUJ : Optimization for: Req8 # o; plan #AXnw

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 224.720 ↑ 1.1 9 1

Limit (cost=21.34..41.87 rows=10 width=144) (actual time=33.089..224.720 rows=9 loops=1)

  • Buffers: shared hit=14525
2. 13.232 224.716 ↑ 918.1 9 1

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

  • Hash Cond: ((tt_trouble_ticket.pilotgroupid)::text = (iai_params_specifiques_eds.eds_params)::text)
  • Buffers: shared hit=14525
3. 211.322 211.322 ↓ 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.020..211.322 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
4. 0.024 0.162 ↑ 1.0 57 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=12
5. 0.102 0.138 ↑ 1.0 57 1

Bitmap Heap Scan on iai_params_specifiques_eds (cost=4.73..20.62 rows=58 width=7) (actual time=0.054..0.138 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
6. 0.036 0.036 ↑ 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.036..0.036 rows=59 loops=1)

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