explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sLKO : Req2 # o

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 523.073 ↑ 1.0 10 1

Limit (cost=76,432.43..76,432.53 rows=10 width=1,770) (actual time=523.059..523.073 rows=10 loops=1)

  • Buffers: shared hit=39373
2. 11.995 523.060 ↑ 4,515.2 10 1

HashAggregate (cost=76,432.43..76,883.95 rows=45,152 width=1,770) (actual time=523.056..523.060 rows=10 loops=1)

  • Group Key: tt_trouble_ticket.ticketid, tt_trouble_ticket.feuillet, tt_alarms.groupid, tt_trouble_ticket.languageid, iai_params_specifiques_eds.organisation, iai_params_specifiques_eds.ajout_bandeau, iai_params_specifiques_eds.actif, 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.old_feuillet, tt_trouble_ticket.horodatage_maj_ticket, tt_trouble_ticket.id_diag_res, tt_trouble_ticket.initgroupid
  • Buffers: shared hit=39373
3. 0.845 511.065 ↑ 4.8 9,462 1

Append (cost=33,459.77..74,513.47 rows=45,152 width=1,770) (actual time=427.673..511.065 rows=9,462 loops=1)

  • Buffers: shared hit=39373
4. 42.179 431.831 ↑ 3.8 9,462 1

HashAggregate (cost=33,459.77..33,821.44 rows=36,167 width=143) (actual time=427.672..431.831 rows=9,462 loops=1)

  • Group Key: tt_trouble_ticket.ticketid, tt_trouble_ticket.feuillet, tt_alarms.groupid, tt_trouble_ticket.languageid, iai_params_specifiques_eds.organisation, iai_params_specifiques_eds.ajout_bandeau, iai_params_specifiques_eds.actif, 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.old_feuillet, tt_trouble_ticket.horodatage_maj_ticket, tt_trouble_ticket.id_diag_res, tt_trouble_ticket.initgroupid
  • Buffers: shared hit=24860
5. 9.636 389.652 ↑ 1.3 28,115 1

Hash Left Join (cost=19,118.52..31,922.67 rows=36,167 width=143) (actual time=314.900..389.652 rows=28,115 loops=1)

  • Hash Cond: ((tt_alarms.groupid)::text = (iai_params_specifiques_eds.eds_params)::text)
  • Buffers: shared hit=24860
6. 31.861 379.651 ↑ 1.3 28,115 1

Hash Join (cost=19,090.42..31,618.98 rows=36,167 width=133) (actual time=314.505..379.651 rows=28,115 loops=1)

  • Hash Cond: ((tt_alarms.fk_ticketid)::text = (tt_trouble_ticket.ticketid)::text)
  • Join Filter: (((tt_trouble_ticket.eds_con_metier)::text <> (tt_alarms.groupid)::text) OR ((tt_trouble_ticket.eds_con_metier IS NULL) AND (tt_alarms.groupid IS NOT NULL)))
  • Rows Removed by Join Filter: 1285
  • Buffers: shared hit=24845
7. 38.464 51.151 ↓ 1.0 50,924 1

Bitmap Heap Scan on tt_alarms (cost=1,080.10..12,966.84 rows=50,539 width=18) (actual time=16.634..51.151 rows=50,924 loops=1)

  • Recheck Cond: ((alarmid)::text = 'AVEYELLOW'::text)
  • Heap Blocks: exact=10134
  • Buffers: shared hit=10332
8. 12.687 12.687 ↓ 1.0 50,924 1

Bitmap Index Scan on tt_alarms_alarmid (cost=0.00..1,067.46 rows=50,539 width=0) (actual time=12.687..12.687 rows=50,924 loops=1)

  • Index Cond: ((alarmid)::text = 'AVEYELLOW'::text)
  • Buffers: shared hit=198
9. 54.370 296.639 ↑ 1.2 74,623 1

Hash (cost=16,880.34..16,880.34 rows=90,399 width=133) (actual time=296.639..296.639 rows=74,623 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 10684kB
  • Buffers: shared hit=14513
10. 242.269 242.269 ↑ 1.2 74,623 1

Seq Scan on tt_trouble_ticket (cost=0.00..16,880.34 rows=90,399 width=133) (actual time=0.027..242.269 rows=74,623 loops=1)

  • Filter: ((issupport IS NULL) AND ((resp_cons_metier IS NULL) OR (resp_cons_metier <> '1'::bpchar)) AND ((currentstatus)::text = ANY ('{0,1,2,3,4}'::text[])))
  • Rows Removed by Filter: 51635
  • Buffers: shared hit=14513
11. 0.157 0.365 ↑ 1.0 580 1

Hash (cost=20.82..20.82 rows=582 width=17) (actual time=0.365..0.365 rows=580 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
  • Buffers: shared hit=15
12. 0.208 0.208 ↑ 1.0 582 1

Seq Scan on iai_params_specifiques_eds (cost=0.00..20.82 rows=582 width=17) (actual time=0.012..0.208 rows=582 loops=1)

  • Buffers: shared hit=15
13. 0.029 78.389 ↓ 0.0 0 1

HashAggregate (cost=40,150.65..40,240.50 rows=8,985 width=143) (actual time=78.389..78.389 rows=0 loops=1)

  • Group Key: tt_trouble_ticket_1.ticketid, tt_trouble_ticket_1.feuillet, tt_trouble_ticket_1.pilotgroupid, tt_trouble_ticket_1.languageid, iai_params_specifiques_eds_1.organisation, iai_params_specifiques_eds_1.ajout_bandeau, iai_params_specifiques_eds_1.actif, tt_trouble_ticket_1.serviceid1value, tt_trouble_ticket_1.serviceid2value, tt_trouble_ticket_1.serviceid3value, tt_trouble_ticket_1.calcul_infos, tt_trouble_ticket_1.servicechangeproduct, tt_trouble_ticket_1.old_serviceid1value, tt_trouble_ticket_1.old_feuillet, tt_trouble_ticket_1.horodatage_maj_ticket, tt_trouble_ticket_1.id_diag_res, tt_trouble_ticket_1.initgroupid
  • Buffers: shared hit=14513
14. 0.000 78.360 ↓ 0.0 0 1

Hash Left Join (cost=15,506.73..39,768.79 rows=8,985 width=143) (actual time=78.360..78.360 rows=0 loops=1)

  • Hash Cond: ((tt_trouble_ticket_1.pilotgroupid)::text = (iai_params_specifiques_eds_1.eds_params)::text)
  • Buffers: shared hit=14513
15. 0.001 78.360 ↓ 0.0 0 1

Hash Anti Join (cost=15,478.63..39,617.15 rows=8,985 width=133) (actual time=78.360..78.360 rows=0 loops=1)

  • Hash Cond: ((tt_trouble_ticket_1.ticketid)::text = (tt_alarms_1.fk_ticketid)::text)
  • Buffers: shared hit=14513
16. 78.359 78.359 ↓ 0.0 0 1

Seq Scan on tt_trouble_ticket tt_trouble_ticket_1 (cost=0.00..17,195.98 rows=23,515 width=133) (actual time=78.359..78.359 rows=0 loops=1)

  • Filter: ((issupport IS NULL) AND (eds_con_metier IS NOT NULL) AND (((eds_con_metier)::text <> (pilotgroupid)::text) OR ((eds_con_metier IS NULL) AND (pilotgroupid IS NOT NULL))) AND ((resp_cons_metier IS NULL) OR (resp_cons_metier <> '1'::bpchar)) AND ((currentstatus)::text = ANY ('{0,1,2,3,4}'::text[])))
  • Rows Removed by Filter: 126258
  • Buffers: shared hit=14513
17. 0.000 0.000 ↓ 0.0 0

Hash (cost=14,312.68..14,312.68 rows=93,276 width=11) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on tt_alarms tt_alarms_1 (cost=1,891.73..14,312.68 rows=93,276 width=11) (never executed)

  • Recheck Cond: ((alarmid)::text = ANY ('{TICAVENT,AVEYELLOW}'::text[]))
19. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on tt_alarms_alarmid (cost=0.00..1,868.41 rows=93,276 width=0) (never executed)

  • Index Cond: ((alarmid)::text = ANY ('{TICAVENT,AVEYELLOW}'::text[]))
20. 0.000 0.000 ↓ 0.0 0

Hash (cost=20.82..20.82 rows=582 width=17) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on iai_params_specifiques_eds iai_params_specifiques_eds_1 (cost=0.00..20.82 rows=582 width=17) (never executed)