explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nGz

options
exclusive inclusive rows x rows loops node
0.000 0.000 ↓ 0.0
→

Limit (cost=30662.52..30667.02 rows=100 width=1542) (actual time=.. rows= loops=)

0.000 0.000 ↓ 0.0
→

Unique (cost=30662.52..30845.90 rows=4075 width=1542) (actual time=.. rows= loops=)

0.000 0.000 ↓ 0.0
→

Sort (cost=30662.52..30672.71 rows=4075 width=1542) (actual time=.. rows= loops=)

  • Sort Key: webelect_feedcontent.published_date, webelect_feedcontent.id, webelect_feedcontent.author_id, webelect_feedcontent.workflow_state, webelect_feedcontent.content, webelect_feedcontent.webelectcomment, webelect_feedcontent.permalink, webelect_feedcontent.sortkey_focus, webelect_feedcontent.sortkey_selection, webelect_feedcontent.online_date, webelect_feedcontent.source_id, webelect_feedcontent.title, webelect_feedcontent.resume, webelect_feedcontent.full_content, webelect_feedcontent.feed_tags, webelect_feedcontent.picture, webelect_feedcontent.related_image_id
0.000 0.000 ↓ 0.0
→

Hash Join (cost=17110.35..27688.17 rows=4075 width=1542) (actual time=.. rows= loops=)

  • Hash Cond: (tagging_taggeditem.object_id = webelect_feedcontent.id)
0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on tagging_taggeditem (cost=546.00..4083.06 rows=18403 width=4) (actual time=.. rows= loops=)

  • Recheck Cond: ((tag_id = ANY ('{41,154,45,181,23}'::integer[])) AND (content_type_id = 21))
0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on tagging_taggeditem_tag_id_key (cost=0.00..541.40 rows=18403 width=0) (actual time=.. rows= loops=)

  • Index Cond: ((tag_id = ANY ('{41,154,45,181,23}'::integer[])) AND (content_type_id = 21))
0.000 0.000 ↓ 0.0
→

Hash (cost=9358.66..9358.66 rows=35335 width=1542) (actual time=.. rows= loops=)

0.000 0.000 ↓ 0.0
→

Seq Scan on webelect_feedcontent (cost=0.00..9358.66 rows=35335 width=1542) (actual time=.. rows= loops=)

  • Filter: ((workflow_state >= 100) AND (workflow_state >= 100))