explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WHh

Settings
# exclusive inclusive rows x rows loops node
1. 0.598 1,223.292 ↑ 146.2 1,468 1

Nested Loop Left Join (cost=2.85..45,365.37 rows=214,646 width=1,226) (actual time=5.050..1,223.292 rows=1,468 loops=1)

2. 0.635 1,218.698 ↓ 1.2 999 1

Nested Loop Left Join (cost=2.28..21,964.74 rows=851 width=1,163) (actual time=4.237..1,218.698 rows=999 loops=1)

3. 0.352 1,211.070 ↓ 1.2 999 1

Nested Loop (cost=1.72..14,660.52 rows=851 width=202) (actual time=3.486..1,211.070 rows=999 loops=1)

4. 0.242 222.707 ↓ 1.2 999 1

Nested Loop (cost=1.15..7,352.56 rows=851 width=210) (actual time=2.677..222.707 rows=999 loops=1)

5. 3.684 3.684 ↓ 1.2 999 1

Index Scan using paper_author_affiliations1_pkey on paper_author_affiliations1 (cost=0.57..44.59 rows=851 width=24) (actual time=1.475..3.684 rows=999 loops=1)

  • Index Cond: ((id > 9000000) AND (id < 9001000))
6. 218.781 218.781 ↑ 1.0 1 999

Index Scan using papers_pkey on papers pa (cost=0.57..8.59 rows=1 width=202) (actual time=0.219..0.219 rows=1 loops=999)

  • Index Cond: (paper_id = paper_author_affiliations1.paper_id)
7. 988.011 988.011 ↑ 1.0 1 999

Index Only Scan using authors_pkey on authors au (cost=0.57..8.59 rows=1 width=8) (actual time=0.989..0.989 rows=1 loops=999)

  • Index Cond: (author_id = paper_author_affiliations1.author_id)
  • Heap Fetches: 999
8. 6.993 6.993 ↓ 0.0 0 999

Index Scan using paper_abstract_paper_id on paper_abstracts abs (cost=0.56..8.57 rows=1 width=969) (actual time=0.007..0.007 rows=0 loops=999)

  • Index Cond: (paper_id = paper_author_affiliations1.paper_id)
9. 3.996 3.996 ↑ 252.0 1 999

Index Scan using paper_urls_paper_id_idx on paper_urls url (cost=0.57..24.98 rows=252 width=68) (actual time=0.003..0.004 rows=1 loops=999)

  • Index Cond: (paper_id = paper_author_affiliations1.paper_id)
Planning time : 0.750 ms
Execution time : 1,223.428 ms