explain.depesz.com

A tool for finding a real cause for slow queries.

Result: FCO

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Limit (cost=18240.87..18241.00 rows=5 width=356) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Unique (cost=18240.87..18540.89 rows=10910 width=356) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Sort (cost=18240.87..18268.14 rows=10910 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((arti
4. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=6929.70..15734.67 rows=10910 width=356) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=6929.70..11372.36 rows=10910 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=6694.38..10908.09 rows=10910 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..2907.65 rows=85057 width=8) (actual time=.. rows= loops=)

  • Filter: art2img_pubblico
8. 0.000 0.000 ↓ 0.0
→

Hash (cost=6417.00..6417.00 rows=5231 width=308) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=3159.82..6417.00 rows=5231 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..3113.45 rows=46564 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=46564 width=0) (actual time=.. rows= loops=)

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

Hash (cost=1812.00..1812.00 rows=9473 width=308) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0
→

Seq Scan on ultimi_articoli articoli (cost=0.00..1812.00 rows=9473 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=8103 width=15) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0
→

Seq Scan on comuni (cost=0.00..134.03 rows=8103 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)