explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 2w6

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=18,240.87..18,241.00 rows=5 width=356) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=18,240.87..18,540.89 rows=10,910 width=356) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=18,240.87..18,268.14 rows=10,910 width=356) (actual time=.. rows= loops=)

  • Sort Key: articoli.art_data_pub, articoli.art_id, articoli.art_titolo, articoli.art_sommario, articoli.art_occhiello, immagini.img_directory, immagini.img_immagine, articoli.art_data_ins, (CASE WHEN (COALESCE(length((articoli.art_altra_localita)::text), 0) = 0) THEN comuni.com_desc ELSE articoli.art_altra_localita END)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6,929.70..15,734.67 rows=10,910 width=356) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,929.70..11,372.36 rows=10,910 width=319) (actual time=.. rows= loops=)

  • Hash Cond: (articoli.art_com_id = comuni.com_id)
6. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=6,694.38..10,908.09 rows=10,910 width=312) (actual time=.. rows= loops=)

  • Hash Cond: (articoli2immagini.art2img_art_id = articoli.art_id)
7. 0.000 0.000 ↓ 0.0

Seq Scan on articoli2immagini (cost=0.00..2,907.65 rows=85,057 width=8) (actual time=.. rows= loops=)

  • Filter: art2img_pubblico
8. 0.000 0.000 ↓ 0.0

Hash (cost=6,417.00..6,417.00 rows=5,231 width=308) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,159.82..6,417.00 rows=5,231 width=308) (actual time=.. rows= loops=)

  • Hash Cond: (articoli2copertine.art2cop_art_id = articoli.art_id)
10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on articoli2copertine (cost=845.40..3,113.45 rows=46,564 width=4) (actual time=.. rows= loops=)

  • Recheck Cond: (art2cop_cop_id = ANY ('{106,101}'::integer[]))
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on articoli2menu_idx (cost=0.00..833.76 rows=46,564 width=0) (actual time=.. rows= loops=)

  • Index Cond: (art2cop_cop_id = ANY ('{106,101}'::integer[]))
12. 0.000 0.000 ↓ 0.0

Hash (cost=1,812.00..1,812.00 rows=9,473 width=308) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on ultimi_articoli articoli (cost=0.00..1,812.00 rows=9,473 width=308) (actual time=.. rows= loops=)

  • Filter: ((art_pak_id = 'IM'::bpchar) AND (art_valid_dir = 1) AND (art_data_pub < now()))
14. 0.000 0.000 ↓ 0.0

Hash (cost=134.03..134.03 rows=8,103 width=15) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on comuni (cost=0.00..134.03 rows=8,103 width=15) (actual time=.. rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using immagini_pk on immagini (cost=0.00..0.38 rows=1 width=45) (actual time=.. rows= loops=)

  • Index Cond: (articoli2immagini.art2img_img_id = img_id)