explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LuCf

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

Limit (cost=128.38..128.38 rows=1 width=6,605) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=128.38..128.38 rows=1 width=6,605) (actual rows= loops=)

  • Sort Key: "MdChapter".id
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..128.37 rows=1 width=6,605) (actual rows= loops=)

  • Join Filter: ("MdChapter".md_comic_id = "MdComic".id)
4. 0.000 0.000 ↓ 0.0

Index Scan using md_chapters_chapter_id_crawled_crawl_status on md_chapters "MdChapter" (cost=0.42..120.05 rows=1 width=4,233) (actual rows= loops=)

  • Index Cond: ((crawled = false) AND (crawl_status IS NULL))
  • Filter: ((NOT crawled) AND (images IS NOT NULL) AND (id <> 387203) AND ((status)::text = 'OK'::text))
5. 0.000 0.000 ↓ 0.0

Index Scan using md_comics_deleted_at_hentai_idx on md_comics "MdComic" (cost=0.29..8.31 rows=1 width=2,372) (actual rows= loops=)

  • Index Cond: ((deleted_at IS NULL) AND (hentai = 0))