explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YylD : Optimization for: plan #UNUM

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.026 ↓ 0.0 0 1

Limit (cost=38.85..38.90 rows=1 width=242) (actual time=0.026..0.026 rows=0 loops=1)

2. 0.000 0.025 ↓ 0.0 0 1

Unique (cost=38.85..38.90 rows=1 width=242) (actual time=0.025..0.025 rows=0 loops=1)

3. 0.018 0.025 ↓ 0.0 0 1

Sort (cost=38.85..38.86 rows=1 width=242) (actual time=0.025..0.025 rows=0 loops=1)

  • Sort Key: ricevutaap0_.id DESC, banca5_.abi, ente4_.codente, ipa3_.codice_ipa, pacchetto2_.identificativo_flusso, ricevutaap0_.data_esito, ipaconfigs7_.utenza_a_2_a, pacchetto2_.prog_flusso, ricevutaap0_.ricevuta_zip_id, ricevutaap0_.identificativo_flusso_bt, ricevutaap0_.esito, ricevutaap0_.stato_easysiope, versioneor1_.numero_ordinativo, versioneor1_.tipo_ordinativo, ricevutaap0_.numerosub, banca5_.descrizione, versioneor1_.id, ricevutaap0_.data_ultimo_aggiornamento, ricevutaac8_.id_connettore
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=5.14..38.84 rows=1 width=242) (actual time=0.007..0.007 rows=0 loops=1)

5. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=4.87..33.45 rows=1 width=178) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (ipa3_.config_siope_id = ipaconfigs7_.id)
6. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=4.87..31.97 rows=1 width=175) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (banca5_.config_siope_id = bancaconfi6_.id)
7. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=4.87..30.70 rows=1 width=183) (actual time=0.007..0.007 rows=0 loops=1)

8. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=4.87..28.54 rows=1 width=153) (actual time=0.007..0.007 rows=0 loops=1)

9. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=4.87..27.19 rows=1 width=137) (actual time=0.006..0.006 rows=0 loops=1)

10. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=4.87..25.89 rows=1 width=122) (actual time=0.006..0.006 rows=0 loops=1)

11. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=4.58..23.61 rows=3 width=51) (actual time=0.006..0.006 rows=0 loops=1)

12. 0.005 0.005 ↓ 0.0 0 1

Index Scan using composite on pacchetto pacchetto2_ (cost=0.28..8.29 rows=1 width=43) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (ipa_id = 11,880,215)
13. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on vers_ord versioneor1_ (cost=4.31..15.29 rows=3 width=24) (never executed)

  • Recheck Cond: (pacchetto_id = pacchetto2_.id)
14. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_pac_eserc_num_ordinativo (cost=0.00..4.30 rows=3 width=0) (never executed)

  • Index Cond: (pacchetto_id = pacchetto2_.id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_ric_appl_search_ord on ric_appl ricevutaap0_ (cost=0.28..0.75 rows=1 width=79) (never executed)

  • Index Cond: (ordinativo_id = versioneor1_.id)
  • Filter: (esercizio = 2,018)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on ipa ipa3_ (cost=0.00..1.28 rows=1 width=31) (never executed)

  • Filter: ((id = 11,880,215) AND (ente_id = 11,880,216))
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on ente ente4_ (cost=0.00..1.34 rows=1 width=24) (never executed)

  • Filter: ((id = 11,880,216) AND (banca_id = 11,880,158))
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on banca banca5_ (cost=0.00..2.15 rows=1 width=38) (never executed)

  • Filter: (id = 11,880,158)
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on banca_cfg_sio bancaconfi6_ (cost=0.00..1.12 rows=12 width=8) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on ipa_cfg_siope ipaconfigs7_ (cost=0.00..1.21 rows=21 width=19) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ric_acc on ric_acc ricevutaac8_ (cost=0.28..5.38 rows=1 width=16) (never executed)

  • Index Cond: (id = ricevutaap0_.ricevuta_accorpata_id)
Planning time : 2.100 ms
Execution time : 0.166 ms