explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mHCo

Settings
# exclusive inclusive rows x rows loops node
1. 2.701 20.011 ↓ 10.0 10 1

Limit (cost=13,559.94..13,559.97 rows=1 width=576) (actual time=17.302..20.011 rows=10 loops=1)

2. 0.009 17.310 ↓ 10.0 10 1

Unique (cost=13,559.94..13,559.97 rows=1 width=576) (actual time=17.300..17.310 rows=10 loops=1)

3. 0.207 17.301 ↓ 10.0 10 1

Sort (cost=13,559.94..13,559.94 rows=1 width=576) (actual time=17.299..17.301 rows=10 loops=1)

  • Sort Key: docs.doc_creation, docs.doc_publication_number, docs.doc_id, docs.doc_is_patent, docs.doc_title, docmetadatas.application_date, docmetadatas.priority_date_earliest, docmetadatas.publication_date, docmetadatas.inventor, docmetadatas.assignee, docmetadatas.cpc, dochtmls.doc_id
  • Sort Method: quicksort Memory: 70kB
4. 0.144 17.094 ↓ 120.0 120 1

Nested Loop Left Join (cost=1,078.44..13,559.93 rows=1 width=576) (actual time=0.937..17.094 rows=120 loops=1)

5. 0.077 16.590 ↓ 120.0 120 1

Nested Loop Left Join (cost=1,078.16..13,559.42 rows=1 width=560) (actual time=0.924..16.590 rows=120 loops=1)

6. 0.000 15.913 ↓ 120.0 120 1

Nested Loop (cost=1,077.73..13,552.51 rows=1 width=98) (actual time=0.917..15.913 rows=120 loops=1)

7. 2.606 14.604 ↓ 906.0 906 1

Gather (cost=1,077.17..13,544.03 rows=1 width=130) (actual time=0.910..14.604 rows=906 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
8. 0.521 11.998 ↓ 453.0 453 2 / 2

Nested Loop (cost=77.17..12,543.93 rows=1 width=130) (actual time=0.460..11.998 rows=453 loops=2)

9. 0.614 5.607 ↓ 209.5 838 2 / 2

Nested Loop (cost=76.61..12,510.01 rows=4 width=114) (actual time=0.267..5.607 rows=838 loops=2)

10. 0.607 0.801 ↑ 1.2 838 2 / 2

Parallel Bitmap Heap Scan on corr_docs_labels corr_docs_labels_inner (cost=76.19..4,840.24 rows=1,023 width=16) (actual time=0.237..0.801 rows=838 loops=2)

  • Recheck Cond: (label_id = '9d3b58c9-e8ff-4d68-baa4-4176af09aac8'::uuid)
  • Filter: (NOT corr_docs_labels_deleted)
  • Heap Blocks: exact=107
11. 0.195 0.195 ↑ 1.0 1,677 1 / 2

Bitmap Index Scan on corr_doc_labels_rows (cost=0.00..75.75 rows=1,739 width=0) (actual time=0.389..0.389 rows=1,677 loops=1)

  • Index Cond: ((label_id = '9d3b58c9-e8ff-4d68-baa4-4176af09aac8'::uuid) AND (corr_docs_labels_deleted = false))
12. 4.192 4.192 ↑ 1.0 1 1,677 / 2

Index Scan using docs_pkey on docs (cost=0.42..7.50 rows=1 width=98) (actual time=0.005..0.005 rows=1 loops=1,677)

  • Index Cond: (doc_id = corr_docs_labels_inner.doc_id)
  • Filter: ((NOT doc_deleted) AND (workspace_id = '27640d72-970a-4451-aab3-d3dd372212d4'::uuid))
13. 5.870 5.870 ↑ 1.0 1 1,677 / 2

Index Only Scan using doc_metadata_filters_row on doc_metadata_filters metadatalegalstatus (cost=0.56..8.47 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=1,677)

  • Index Cond: ((doc_id = docs.doc_id) AND (label = 'legal_status'::text) AND (value = 'Alive'::text))
  • Heap Fetches: 906
14. 3.624 3.624 ↓ 0.0 0 906

Index Only Scan using doc_metadata_filters_row on doc_metadata_filters metadataapplicationstatus (cost=0.56..8.47 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=906)

  • Index Cond: ((doc_id = docs.doc_id) AND (label = 'application_status'::text) AND (value = 'Granted'::text))
  • Heap Fetches: 120
15. 0.600 0.600 ↑ 1.0 1 120

Index Scan using doc_metadata_doc_id on doc_metadata docmetadatas (cost=0.42..6.90 rows=1 width=478) (actual time=0.004..0.005 rows=1 loops=120)

  • Index Cond: (docs.doc_id = doc_id)
16. 0.360 0.360 ↑ 1.0 1 120

Index Scan using doc_html_doc_id on doc_html dochtmls (cost=0.28..0.49 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=120)

  • Index Cond: (docs.doc_id = doc_id)
  • Filter: (NOT doc_html_deleted)