explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0IL

Settings
# exclusive inclusive rows x rows loops node
1. 0.295 92.930 ↓ 21.0 21 1

Nested Loop (cost=2.25..16.79 rows=1 width=5,969) (actual time=7.364..92.930 rows=21 loops=1)

  • Join Filter: (ir.systemtype_id = syst.id)
2. 0.232 91.522 ↓ 21.0 21 1

Nested Loop Left Join (cost=2.25..14.25 rows=1 width=5,853) (actual time=7.283..91.522 rows=21 loops=1)

3. 0.367 37.698 ↓ 21.0 21 1

Nested Loop Left Join (cost=1.83..13.75 rows=1 width=3,151) (actual time=0.914..37.698 rows=21 loops=1)

  • Join Filter: (tx.pathogenrefid_id = p.id)
  • Rows Removed by Join Filter: 42
4. 2.327 37.184 ↓ 21.0 21 1

Nested Loop (cost=1.83..12.71 rows=1 width=3,042) (actual time=0.881..37.184 rows=21 loops=1)

5. 3.183 32.469 ↓ 398.0 398 1

Nested Loop (cost=1.54..12.37 rows=1 width=1,866) (actual time=0.125..32.469 rows=398 loops=1)

6. 3.293 26.102 ↓ 398.0 398 1

Nested Loop (cost=1.25..12.02 rows=1 width=228) (actual time=0.076..26.102 rows=398 loops=1)

7. 4.594 20.023 ↓ 398.0 398 1

Nested Loop (cost=0.96..11.70 rows=1 width=204) (actual time=0.061..20.023 rows=398 loops=1)

8. 5.247 12.389 ↓ 608.0 608 1

Nested Loop (cost=0.67..11.38 rows=1 width=188) (actual time=0.041..12.389 rows=608 loops=1)

9. 1.670 1.670 ↓ 608.0 608 1

Index Scan using idx7_resultreview on resultreview ir (cost=0.25..4.93 rows=1 width=68) (actual time=0.017..1.670 rows=608 loops=1)

10. 5.472 5.472 ↑ 1.0 1 608

Index Scan using idx5_testresult on testresult tr (cost=0.42..6.44 rows=1 width=120) (actual time=0.008..0.009 rows=1 loops=608)

  • Index Cond: (id = ir.reviewresult_id)
11. 3.040 3.040 ↑ 1.0 1 608

Index Only Scan using idx1_linkidentitems on linkidentitems identitems (cost=0.29..0.31 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=608)

  • Index Cond: (identifications_id = tr.identifications_id)
  • Heap Fetches: 0
12. 2.786 2.786 ↑ 1.0 1 398

Index Scan using identifications_pkey on identifications ident (cost=0.29..0.31 rows=1 width=24) (actual time=0.006..0.007 rows=1 loops=398)

  • Index Cond: (id = tr.identifications_id)
13. 3.184 3.184 ↑ 1.0 1 398

Index Scan using identificationitem_pkey on identificationitem identitem (cost=0.29..0.34 rows=1 width=1,638) (actual time=0.006..0.008 rows=1 loops=398)

  • Index Cond: (id = identitems.items_id)
14. 2.388 2.388 ↓ 0.0 0 398

Index Scan using taxon_pkey on taxon tx (cost=0.28..0.33 rows=1 width=1,176) (actual time=0.006..0.006 rows=0 loops=398)

  • Index Cond: (id = identitem.organism_id)
  • Filter: (refid = '103446'::bigint)
  • Rows Removed by Filter: 1
15. 0.147 0.147 ↑ 1.0 2 21

Seq Scan on pathogen p (cost=0.00..1.02 rows=2 width=109) (actual time=0.005..0.007 rows=2 loops=21)

16. 53.592 53.592 ↑ 1.0 1 21

Index Scan using commontestresult_pkey on commontestresult ctr (cost=0.42..0.48 rows=1 width=2,702) (actual time=2.550..2.552 rows=1 loops=21)

  • Index Cond: (id = tr.commonpart_id)
17. 1.113 1.113 ↑ 1.0 1 21

Seq Scan on systemtype syst (cost=0.00..2.52 rows=1 width=116) (actual time=0.044..0.053 rows=1 loops=21)

  • Filter: (upper((type)::text) ~~ '%MSID%'::text)
  • Rows Removed by Filter: 34
Planning time : 6.359 ms
Execution time : 93.305 ms