explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b1je

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 9,617.911 ↑ 1.0 1 1

Result (cost=2,395,933.46..2,395,933.47 rows=1 width=1) (actual time=9,617.907..9,617.911 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.003 1.618 ↓ 0.0 0 1

Limit (cost=2.14..91.78 rows=1 width=4) (actual time=1.618..1.618 rows=0 loops=1)

4. 0.003 1.615 ↓ 0.0 0 1

Nested Loop (cost=2.14..91.78 rows=1 width=4) (actual time=1.615..1.615 rows=0 loops=1)

5. 0.002 1.612 ↓ 0.0 0 1

Nested Loop (cost=1.57..88.98 rows=1 width=4) (actual time=1.612..1.612 rows=0 loops=1)

6. 0.002 1.610 ↓ 0.0 0 1

Nested Loop (cost=1.01..88.34 rows=1 width=8) (actual time=1.610..1.610 rows=0 loops=1)

7. 1.608 1.608 ↓ 0.0 0 1

Index Scan using pats_invention_link_current_pat_id_idx on pats_invention_link pil (cost=0.43..5.75 rows=4 width=8) (actual time=1.608..1.608 rows=0 loops=1)

  • Index Cond: (current_pat_id = 100025680)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using int_pat_related_documents_related_core_pat_id_idx on int_pat_related_documents (cost=0.57..20.64 rows=1 width=8) (never executed)

  • Index Cond: (related_core_pat_id = pil.pat_id)
  • Filter: ((relation_type)::text <> ALL ('{provisional,related-publication}'::text[]))
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_pat_family_pats_publication_id on pat_family_pats (cost=0.57..0.63 rows=1 width=4) (never executed)

  • Index Cond: (publication_id = int_pat_related_documents.publication_id)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Scan using all_pats_new_pkey on all_pats (cost=0.57..2.79 rows=1 width=4) (never executed)

  • Index Cond: (id = 100025680)
  • Filter: (pat_source = 'core'::text)
11. 0.003 9,616.278 ↓ 0.0 0 1

Limit (cost=1.83..2,395,841.68 rows=1 width=4) (actual time=9,616.278..9,616.278 rows=0 loops=1)

12. 0.005 9,616.275 ↓ 0.0 0 1

Nested Loop (cost=1.83..2,395,841.68 rows=1 width=4) (actual time=9,616.275..9,616.275 rows=0 loops=1)

13. 0.018 9,616.270 ↓ 0.0 0 1

Nested Loop (cost=1.26..2,395,841.04 rows=1 width=4) (actual time=9,616.270..9,616.270 rows=0 loops=1)

14. 0.121 0.121 ↑ 1.0 1 1

Index Scan using int_pats_bkp_pkey on int_pats (cost=0.57..2.80 rows=1 width=4) (actual time=0.077..0.121 rows=1 loops=1)

  • Index Cond: (id = 100025680)
  • Filter: (((doc_kind_code)::text <> 'W0'::text) AND (title <> 'No title available'::text) AND (country_code <> 'US'::bpchar) AND CASE WHEN (issue_date IS NOT NULL) THEN (issue_date >= '1976-01-01'::date) ELSE (app_filing_date >= '1976-01-01'::date) END)
15. 9,616.131 9,616.131 ↓ 0.0 0 1

Index Only Scan using int_pat_related_documents_uk on int_pat_related_documents int_pat_related_documents_1 (cost=0.70..2,395,838.23 rows=1 width=8) (actual time=9,616.131..9,616.131 rows=0 loops=1)

  • Index Cond: (related_publication_id = int_pats.publication_id)
  • Filter: ((relation_type)::text <> ALL ('{provisional,related-publication}'::text[]))
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_pat_family_pats_publication_id on pat_family_pats pat_family_pats_1 (cost=0.57..0.63 rows=1 width=4) (never executed)

  • Index Cond: (publication_id = int_pat_related_documents_1.publication_id)
  • Heap Fetches: 0