explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aYIi

Settings
# exclusive inclusive rows x rows loops node
1. 0.506 288.585 ↑ 1.0 1 1

Aggregate (cost=8,172.86..8,172.87 rows=1 width=8) (actual time=288.583..288.585 rows=1 loops=1)

2. 2.599 288.079 ↓ 206.0 206 1

Nested Loop (cost=860.06..8,172.86 rows=1 width=8) (actual time=202.400..288.079 rows=206 loops=1)

3. 2.453 282.596 ↓ 206.0 206 1

Nested Loop (cost=859.92..8,172.68 rows=1 width=16) (actual time=202.354..282.596 rows=206 loops=1)

4. 7.488 277.671 ↓ 206.0 206 1

Hash Join (cost=859.63..8,172.36 rows=1 width=32) (actual time=202.285..277.671 rows=206 loops=1)

  • Hash Cond: (tr.identifications_id = identitems.identifications_id)
5. 30.457 68.955 ↑ 1.0 2,751 1

Nested Loop (cost=0.71..7,303.12 rows=2,751 width=24) (actual time=0.112..68.955 rows=2,751 loops=1)

6. 8.237 8.237 ↑ 1.0 2,751 1

Index Only Scan using idx1_resultreview on resultreview ir (cost=0.29..122.17 rows=2,751 width=24) (actual time=0.074..8.237 rows=2,751 loops=1)

  • Index Cond: ((status = ANY ('{ToReview,Refused,InProgress,ToSolve}'::text[])) AND (display = true))
  • Filter: display
  • Heap Fetches: 0
7. 30.261 30.261 ↑ 1.0 1 2,751

Index Only Scan using idx5_testresult on testresult tr (cost=0.42..2.60 rows=1 width=24) (actual time=0.009..0.011 rows=1 loops=2,751)

  • Index Cond: (id = ir.reviewresult_id)
  • Heap Fetches: 0
8. 15.074 201.228 ↓ 1,234.7 7,408 1

Hash (cost=858.84..858.84 rows=6 width=8) (actual time=201.228..201.228 rows=7,408 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 354kB
9. 70.503 186.154 ↓ 1,234.7 7,408 1

Nested Loop (cost=0.86..858.84 rows=6 width=8) (actual time=0.091..186.154 rows=7,408 loops=1)

10. 19.862 34.163 ↓ 1,234.7 7,408 1

Nested Loop (cost=0.57..856.79 rows=6 width=8) (actual time=0.070..34.163 rows=7,408 loops=1)

11. 0.027 0.027 ↑ 1.0 1 1

Index Scan using idx1_taxon on taxon tx (cost=0.28..6.30 rows=1 width=16) (actual time=0.023..0.027 rows=1 loops=1)

  • Index Cond: (refid = '103446'::bigint)
12. 14.274 14.274 ↓ 51.4 7,408 1

Index Only Scan using idx1_identificationitem on identificationitem identitem (cost=0.29..849.05 rows=144 width=16) (actual time=0.025..14.274 rows=7,408 loops=1)

  • Index Cond: (organism_id = tx.id)
  • Heap Fetches: 0
13. 81.488 81.488 ↑ 1.0 1 7,408

Index Scan using linkidentitems_items_id_key on linkidentitems identitems (cost=0.29..0.33 rows=1 width=16) (actual time=0.010..0.011 rows=1 loops=7,408)

  • Index Cond: (items_id = identitem.id)
14. 2.472 2.472 ↑ 1.0 1 206

Index Only Scan using identifications_pkey on identifications ident (cost=0.29..0.31 rows=1 width=8) (actual time=0.010..0.012 rows=1 loops=206)

  • Index Cond: (id = tr.identifications_id)
  • Heap Fetches: 0
15. 2.884 2.884 ↑ 1.0 1 206

Index Scan using systemtype_pkey on systemtype syst (cost=0.14..0.17 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=206)

  • Index Cond: (id = ir.systemtype_id)
  • Filter: (upper((type)::text) ~~ '%MSID%'::text)
Planning time : 6.386 ms
Execution time : 289.068 ms