explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLqk

Settings
# exclusive inclusive rows x rows loops node
1. 11.968 109.455 ↓ 3,696.0 3,696 1

Nested Loop Anti Join (cost=174.36..48,855.78 rows=1 width=1,162) (actual time=2.454..109.455 rows=3,696 loops=1)

2. 16.351 17.671 ↓ 1.0 7,256 1

Bitmap Heap Scan on documents (cost=173.81..15,690.90 rows=7,211 width=1,162) (actual time=2.432..17.671 rows=7,256 loops=1)

  • Recheck Cond: (doc_type = 'plt-document-content'::text)
  • Filter: (doc_version IS NOT NULL)
  • Heap Blocks: exact=5770
3. 1.320 1.320 ↓ 1.0 7,256 1

Bitmap Index Scan on doc_type_documents (cost=0.00..172.01 rows=7,211 width=0) (actual time=1.319..1.320 rows=7,256 loops=1)

  • Index Cond: (doc_type = 'plt-document-content'::text)
4. 79.816 79.816 ↓ 0.0 0 7,256

Index Only Scan using deleted_docs_pkey on deleted_docs (cost=0.55..4.59 rows=1 width=75) (actual time=0.011..0.011 rows=0 loops=7,256)

  • Index Cond: ((doc_id = documents.doc_id) AND (channel_id = documents.channel_id))
  • Heap Fetches: 3560