explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ird3

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 9,655.857 ↑ 1.0 1 1

Aggregate (cost=261,639.85..261,639.86 rows=1 width=0) (actual time=9,655.856..9,655.857 rows=1 loops=1)

  • Buffers: shared hit=86560 read=50667
2. 0.058 9,655.822 ↓ 9.0 18 1

Unique (cost=261,639.40..261,639.83 rows=2 width=1,375) (actual time=9,655.751..9,655.822 rows=18 loops=1)

  • Buffers: shared hit=86560 read=50667
3. 0.196 9,655.764 ↓ 9.0 18 1

Sort (cost=261,639.40..261,639.41 rows=2 width=1,375) (actual time=9,655.749..9,655.764 rows=18 loops=1)

  • Sort Key: rice.id_ricevuta_telematica, ricer.id_pagamento_singolo_ric, rice.codice_ipa_creditore, rice.ident_dominio, rice.ident_univoco_versamento, rice.codice_contesto_pagamento, rice.codice_ipa, rice.identificativo_psp, rice.stato_riconciliazione_debiti, rice.tipo_versamento, rice.rif_messaggio_richiesta, rice.esito_pagamento, rice.sog_deb_identificativo_univoco, rice.sog_deb_nominativo, rice.sog_vers_identificativo_univoco, rice.sog_vers_nominativo, rice.ist_attest_identificativo_univoco, rice.ist_attest_tipo_identificativo, rice.ist_attest_denominazione, ricer.importo_singolo_pagamento, ricer.causale_versamento, ricer.data_esito_pagamento_singolo, ricer.identificativo_univoco_riscossione, pagtr.id_pagamento_singolo, pagt.id_pagamento_telematico, pagt.ident_univoco_versamento, pagt.stato_payservice, pagt.stato_notifica, pagt.ident_dominio, pagt.codice_contesto_pagamento, deb.id_debito, deb.codice_ipa, deb.codice_servizio, deb.codice_ipa_creditore, deb.codice_tipo_debito, deb.sog_deb_identificativo_univoco, deb.sog_deb_nominativo, deb.ident_transazione, deb.importo, deb.stato_debito, deb.rec_tms_ins, deb.ideb, deb.iposdeb, deb.numero_avviso, deb.iuv_numero_avviso, deb.cod_applic_numero_avviso, deb.codice_lotto, rico.id_riconciliazione, rico.ident_univoco_riscossione, rico.codice_ipa_creditore, rico.deb_codice_tipo_debito, rico.deb_iddeb, rico.deb_idpos, rico.deb_importo, rico.deb_progr_versione, rico.rendic_data_ora_flusso, rico.rendic_data_regolamento, rico.rendic_ident_flusso, rico.rendic_ident_univoco_mitten, rico.rendic_ident_univoco_regolamento, rico.rendic_ident_univoco_riceven, rico.rendic_importo_pag_sing, rico.riconciliazione_esito, rico.riconciliazione_messaggi, rico.rif_id_debito, rico.rif_id_flusso_rendicont, rico.rif_id_flusso_rendicont_riga, rico.rif_id_pagamento_singolo, rico.rif_id_pagamento_singolo_ric, rico.rif_id_pagamento_telematico, rico.rif_id_ricevuta_telematica, rend1.id_flusso_rendicont, rendr1.id_flusso_rendicont_riga, rend1.ident_flusso, rend1.ident_univoco_regolamento, rend1.ident_univoco_mittente, rend1.tipo_ident_univoco_mittente, rend1.denominazione_mittente, rend1.data_ora_flusso, rend1.data_regolamento, rend1.stato_elaborazione, rendr1.ident_univoco_versamento, rendr1.data_esito_singolo_pagamento, rendr1.ident_univoco_riscossione
  • Sort Method: quicksort Memory: 59kB
  • Buffers: shared hit=86560 read=50667
4. 0.030 9,655.568 ↓ 9.0 18 1

Append (cost=34,471.11..261,639.39 rows=2 width=1,375) (actual time=501.164..9,655.568 rows=18 loops=1)

  • Buffers: shared hit=86544 read=50667
5. 0.061 512.832 ↓ 17.0 17 1

Nested Loop Left Join (cost=34,471.11..57,244.67 rows=1 width=1,375) (actual time=501.162..512.832 rows=17 loops=1)

  • Buffers: shared hit=26722 read=54
6. 0.066 512.584 ↓ 17.0 17 1

Nested Loop Left Join (cost=34,470.69..57,244.07 rows=1 width=1,369) (actual time=501.091..512.584 rows=17 loops=1)

  • Buffers: shared hit=26658 read=49
7. 0.076 512.348 ↓ 17.0 17 1

Nested Loop Left Join (cost=34,470.27..57,243.38 rows=1 width=1,295) (actual time=501.066..512.348 rows=17 loops=1)

  • Filter: (((deb.codice_ipa)::text = 'c_a176'::text) OR ((rice.codice_ipa)::text = 'c_a176'::text))
  • Buffers: shared hit=26599 read=40
8. 0.101 512.136 ↓ 17.0 17 1

Nested Loop Left Join (cost=34,469.85..57,242.61 rows=1 width=1,086) (actual time=501.039..512.136 rows=17 loops=1)

  • Buffers: shared hit=26534 read=37
9. 0.057 511.865 ↓ 17.0 17 1

Nested Loop Left Join (cost=34,469.43..57,242.02 rows=1 width=985) (actual time=500.993..511.865 rows=17 loops=1)

  • Buffers: shared hit=26480 read=23
10. 251.458 511.706 ↓ 17.0 17 1

Hash Join (cost=34,468.59..57,240.56 rows=1 width=814) (actual time=500.952..511.706 rows=17 loops=1)

  • Hash Cond: (rico.rif_id_debito = deb.id_debito)
  • Join Filter: (((rico.codice_ipa_creditore)::text = 'c_a176'::text) OR ((deb.codice_ipa_creditore)::text = 'c_a176'::text) OR ((rico.codice_ipa_creditore)::text = 'c_a176'::text))
  • Buffers: shared hit=26429 read=23
11. 216.097 216.097 ↑ 1.0 236,181 1

Seq Scan on jcg_ppa_riconciliazione rico (cost=0.00..21,873.86 rows=239,486 width=613) (actual time=0.016..216.097 rows=236,181 loops=1)

  • Buffers: shared hit=19479
12. 0.032 44.151 ↓ 3.0 18 1

Hash (cost=34,468.52..34,468.52 rows=6 width=201) (actual time=44.151..44.151 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
  • Buffers: shared hit=6947 read=23
13. 44.119 44.119 ↓ 3.0 18 1

Index Scan using jcg_ppa_debito_codice_ipa_codice_ipa_creditore_codice_tipo__key on jcg_ppa_debito deb (cost=0.55..34,468.52 rows=6 width=201) (actual time=0.283..44.119 rows=18 loops=1)

  • Index Cond: ((codice_ipa_creditore)::text = 'c_a176'::text)
  • Filter: ((id_debito IS NOT NULL) AND ((stato_debito)::text <> 'CANCELLATO_LOGICAMENTE'::text) AND (rec_tms_ins >= '2019-10-03 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 38
  • Buffers: shared hit=6947 read=23
14. 0.034 0.102 ↓ 0.0 0 17

Nested Loop (cost=0.84..1.45 rows=1 width=171) (actual time=0.006..0.006 rows=0 loops=17)

  • Buffers: shared hit=51
15. 0.068 0.068 ↓ 0.0 0 17

Index Scan using jcg_ppa_flusso_rendicont_riga_pkey on jcg_ppa_flusso_rendicont_riga rendr1 (cost=0.42..0.71 rows=1 width=51) (actual time=0.004..0.004 rows=0 loops=17)

  • Index Cond: (id_flusso_rendicont_riga = rico.rif_id_flusso_rendicont_riga)
  • Buffers: shared hit=51
16. 0.000 0.000 ↓ 0.0 0

Index Scan using jcg_ppa_flusso_rendicont_pkey on jcg_ppa_flusso_rendicont rend1 (cost=0.42..0.73 rows=1 width=126) (never executed)

  • Index Cond: (id_flusso_rendicont = rendr1.id_flusso_rendicont)
17. 0.170 0.170 ↑ 1.0 1 17

Index Scan using jcg_ppa_pagamento_singolo_ric_pkey on jcg_ppa_pagamento_singolo_ric ricer (cost=0.42..0.58 rows=1 width=101) (actual time=0.009..0.010 rows=1 loops=17)

  • Index Cond: (rico.rif_id_pagamento_singolo_ric = id_pagamento_singolo_ric)
  • Buffers: shared hit=54 read=14
18. 0.136 0.136 ↑ 1.0 1 17

Index Scan using jcg_ppa_ricevuta_telematica_pkey on jcg_ppa_ricevuta_telematica rice (cost=0.42..0.76 rows=1 width=209) (actual time=0.007..0.008 rows=1 loops=17)

  • Index Cond: (rico.rif_id_ricevuta_telematica = id_ricevuta_telematica)
  • Buffers: shared hit=65 read=3
19. 0.170 0.170 ↑ 1.0 1 17

Index Scan using jcg_ppa_pagamento_telematico_pkey on jcg_ppa_pagamento_telematico pagt (cost=0.42..0.68 rows=1 width=74) (actual time=0.009..0.010 rows=1 loops=17)

  • Index Cond: (rico.rif_id_pagamento_telematico = id_pagamento_telematico)
  • Buffers: shared hit=59 read=9
20. 0.187 0.187 ↑ 1.0 1 17

Index Only Scan using jcg_ppa_pagamento_singolo_pkey on jcg_ppa_pagamento_singolo pagtr (cost=0.42..0.59 rows=1 width=6) (actual time=0.009..0.011 rows=1 loops=17)

  • Index Cond: (id_pagamento_singolo = rico.rif_id_pagamento_singolo)
  • Heap Fetches: 17
  • Buffers: shared hit=64 read=5
21. 228.036 9,142.706 ↑ 1.0 1 1

Hash Right Join (cost=187,496.34..204,394.70 rows=1 width=1,375) (actual time=9,142.704..9,142.706 rows=1 loops=1)

  • Hash Cond: (pagtr_1.id_debito = deb_1.id_debito)
  • Filter: ((rico1.rif_id_pagamento_singolo_ric IS NULL) AND (((deb_1.codice_ipa)::text = 'c_a176'::text) OR ((rice_1.codice_ipa)::text = 'c_a176'::text)) AND (((rico1.ident_univoco_riscossione)::text = 'c_a176'::text) OR ((deb_1.codice_ipa_creditore)::text = 'c_a176'::text) OR ((rico1.ident_univoco_riscossione)::text = 'c_a176'::text)))
  • Rows Removed by Filter: 17
  • Buffers: shared hit=59822 read=50613
22. 922.090 8,883.077 ↓ 1.0 240,713 1

Hash Left Join (cost=153,027.75..169,028.76 rows=239,282 width=1,180) (actual time=7,704.286..8,883.077 rows=240,713 loops=1)

  • Hash Cond: (pagtr_1.id_pagamento_telematico = pagt_1.id_pagamento_telematico)
  • Buffers: shared hit=52852 read=50613
23. 256.881 256.881 ↑ 1.0 239,051 1

Seq Scan on jcg_ppa_pagamento_singolo pagtr_1 (cost=0.00..10,917.82 rows=239,282 width=18) (actual time=0.010..256.881 rows=239,051 loops=1)

  • Buffers: shared hit=2 read=8523
24. 619.194 7,704.106 ↓ 1.0 239,252 1

Hash (cost=150,046.08..150,046.08 rows=238,533 width=1,168) (actual time=7,704.106..7,704.106 rows=239,252 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 165518kB
  • Buffers: shared hit=52850 read=42090
25. 798.926 7,084.912 ↓ 1.0 239,252 1

Hash Right Join (cost=106,807.56..150,046.08 rows=238,533 width=1,168) (actual time=3,727.680..7,084.912 rows=239,252 loops=1)

  • Hash Cond: (rico1.rif_id_pagamento_telematico = pagt_1.id_pagamento_telematico)
  • Buffers: shared hit=52850 read=42090
26. 764.279 5,683.496 ↑ 1.0 236,178 1

Hash Join (cost=87,629.57..125,830.04 rows=237,085 width=1,094) (actual time=3,125.019..5,683.496 rows=236,178 loops=1)

  • Hash Cond: (rico1.rif_id_pagamento_singolo_ric = ricer_1.id_pagamento_singolo_ric)
  • Buffers: shared hit=52773 read=28356
27. 677.196 4,316.173 ↑ 1.0 236,178 1

Hash Left Join (cost=74,180.89..107,343.30 rows=237,085 width=993) (actual time=2,521.831..4,316.173 rows=236,178 loops=1)

  • Hash Cond: (rico1.rif_id_flusso_rendicont_riga = rendr1_1.id_flusso_rendicont_riga)
  • Join Filter: (rico1.rif_id_flusso_rendicont_riga = (-1)::numeric)
  • Rows Removed by Join Filter: 135530
  • Buffers: shared hit=52760 read=20336
28. 893.887 1,908.805 ↑ 1.0 236,178 1

Hash Join (cost=23,681.48..50,620.41 rows=237,085 width=822) (actual time=791.505..1,908.805 rows=236,178 loops=1)

  • Hash Cond: (rico1.rif_id_ricevuta_telematica = rice_1.id_ricevuta_telematica)
  • Buffers: shared hit=37851
29. 223.587 223.587 ↑ 1.0 236,181 1

Seq Scan on jcg_ppa_riconciliazione rico1 (cost=0.00..21,873.86 rows=239,486 width=613) (actual time=0.004..223.587 rows=236,181 loops=1)

  • Buffers: shared hit=19479
30. 354.047 791.331 ↑ 1.0 235,878 1

Hash (cost=20,731.77..20,731.77 rows=235,977 width=209) (actual time=791.331..791.331 rows=235,878 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 54661kB
  • Buffers: shared hit=18372
31. 437.284 437.284 ↑ 1.0 235,878 1

Seq Scan on jcg_ppa_ricevuta_telematica rice_1 (cost=0.00..20,731.77 rows=235,977 width=209) (actual time=0.008..437.284 rows=235,878 loops=1)

  • Buffers: shared hit=18372
32. 405.979 1,730.172 ↓ 1.0 297,311 1

Hash (cost=46,807.48..46,807.48 rows=295,354 width=171) (actual time=1,730.172..1,730.172 rows=297,311 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 62857kB
  • Buffers: shared hit=14909 read=20336
33. 762.205 1,324.193 ↓ 1.0 297,311 1

Hash Join (cost=21,932.28..46,807.48 rows=295,354 width=171) (actual time=297.369..1,324.193 rows=297,311 loops=1)

  • Hash Cond: (rendr1_1.id_flusso_rendicont = rend1_1.id_flusso_rendicont)
  • Buffers: shared hit=14909 read=20336
34. 264.678 264.678 ↓ 1.0 297,311 1

Seq Scan on jcg_ppa_flusso_rendicont_riga rendr1_1 (cost=0.00..17,860.54 rows=295,354 width=51) (actual time=0.006..264.678 rows=297,311 loops=1)

  • Buffers: shared hit=14907
35. 97.168 297.310 ↓ 1.0 71,409 1

Hash (cost=21,046.57..21,046.57 rows=70,857 width=126) (actual time=297.310..297.310 rows=71,409 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 11487kB
  • Buffers: shared hit=2 read=20336
36. 200.142 200.142 ↓ 1.0 71,409 1

Seq Scan on jcg_ppa_flusso_rendicont rend1_1 (cost=0.00..21,046.57 rows=70,857 width=126) (actual time=0.003..200.142 rows=71,409 loops=1)

  • Buffers: shared hit=2 read=20336
37. 275.879 603.044 ↑ 1.0 236,501 1

Hash (cost=10,439.97..10,439.97 rows=240,697 width=101) (actual time=603.044..603.044 rows=236,501 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 31745kB
  • Buffers: shared hit=13 read=8020
38. 327.165 327.165 ↑ 1.0 236,501 1

Seq Scan on jcg_ppa_pagamento_singolo_ric ricer_1 (cost=0.00..10,439.97 rows=240,697 width=101) (actual time=0.010..327.165 rows=236,501 loops=1)

  • Buffers: shared hit=13 read=8020
39. 259.393 602.490 ↑ 1.0 238,415 1

Hash (cost=16,196.33..16,196.33 rows=238,533 width=74) (actual time=602.490..602.490 rows=238,415 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 23454kB
  • Buffers: shared hit=77 read=13734
40. 343.097 343.097 ↑ 1.0 238,415 1

Seq Scan on jcg_ppa_pagamento_telematico pagt_1 (cost=0.00..16,196.33 rows=238,533 width=74) (actual time=0.007..343.097 rows=238,415 loops=1)

  • Buffers: shared hit=77 read=13734
41. 0.035 31.593 ↓ 3.0 18 1

Hash (cost=34,468.52..34,468.52 rows=6 width=201) (actual time=31.593..31.593 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
  • Buffers: shared hit=6970
42. 31.558 31.558 ↓ 3.0 18 1

Index Scan using jcg_ppa_debito_codice_ipa_codice_ipa_creditore_codice_tipo__key on jcg_ppa_debito deb_1 (cost=0.55..34,468.52 rows=6 width=201) (actual time=0.096..31.558 rows=18 loops=1)

  • Index Cond: ((codice_ipa_creditore)::text = 'c_a176'::text)
  • Filter: ((id_debito IS NOT NULL) AND ((stato_debito)::text <> 'CANCELLATO_LOGICAMENTE'::text) AND (rec_tms_ins >= '2019-10-03 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 38
  • Buffers: shared hit=6970
Planning time : 11.549 ms
Execution time : 9,671.319 ms