explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrpV

Settings
# exclusive inclusive rows x rows loops node
1. 0.230 1,255.713 ↑ 1.0 1 1

Aggregate (cost=15,656.40..15,656.41 rows=1 width=8) (actual time=1,255.712..1,255.713 rows=1 loops=1)

2. 0.489 1,255.483 ↓ 206.0 206 1

Hash Join (cost=14,228.39..15,656.40 rows=1 width=8) (actual time=1,071.793..1,255.483 rows=206 loops=1)

  • Hash Cond: (ir.systemtype_id = syst.id)
3. 3.325 1,254.886 ↓ 206.0 206 1

Hash Join (cost=14,225.85..15,653.84 rows=1 width=16) (actual time=1,071.605..1,254.886 rows=206 loops=1)

  • Hash Cond: (identitems.items_id = identitem.id)
4. 47.305 1,118.180 ↑ 1.1 2,267 1

Merge Join (cost=13,197.98..14,616.93 rows=2,410 width=24) (actual time=937.991..1,118.180 rows=2,267 loops=1)

  • Merge Cond: (tr.identifications_id = ident.id)
5. 42.190 1,022.928 ↓ 9.1 2,267 1

Merge Join (cost=13,184.85..14,465.23 rows=248 width=40) (actual time=937.941..1,022.928 rows=2,267 loops=1)

  • Merge Cond: (identitems.identifications_id = tr.identifications_id)
6. 39.958 39.958 ↑ 1.0 44,151 1

Index Only Scan using idx1_linkidentitems on linkidentitems identitems (cost=0.29..1,178.93 rows=44,176 width=16) (actual time=0.040..39.958 rows=44,151 loops=1)

  • Heap Fetches: 0
7. 7.268 940.780 ↑ 1.0 2,751 1

Sort (cost=13,171.99..13,178.86 rows=2,751 width=24) (actual time=937.865..940.780 rows=2,751 loops=1)

  • Sort Key: tr.identifications_id
  • Sort Method: quicksort Memory: 311kB
8. 493.922 933.512 ↑ 1.0 2,751 1

Hash Join (cost=156.56..13,014.83 rows=2,751 width=24) (actual time=10.811..933.512 rows=2,751 loops=1)

  • Hash Cond: (tr.id = ir.reviewresult_id)
9. 429.129 429.129 ↑ 1.0 489,437 1

Seq Scan on testresult tr (cost=0.00..10,995.37 rows=489,437 width=24) (actual time=0.029..429.129 rows=489,437 loops=1)

10. 4.805 10.461 ↑ 1.0 2,751 1

Hash (cost=122.17..122.17 rows=2,751 width=24) (actual time=10.461..10.461 rows=2,751 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 183kB
11. 5.656 5.656 ↑ 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.047..5.656 rows=2,751 loops=1)

  • Index Cond: ((status = ANY ('{ToReview,Refused,InProgress,ToSolve}'::text[])) AND (display = true))
  • Filter: display
  • Heap Fetches: 0
12. 47.947 47.947 ↑ 1.0 50,396 1

Index Only Scan using identifications_pkey on identifications ident (cost=0.29..1,176.64 rows=50,423 width=8) (actual time=0.020..47.947 rows=50,396 loops=1)

  • Heap Fetches: 0
13. 11.080 133.381 ↓ 1,234.7 7,408 1

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

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 354kB
14. 69.892 122.301 ↓ 1,234.7 7,408 1

Hash Join (cost=6.31..1,027.79 rows=6 width=8) (actual time=0.093..122.301 rows=7,408 loops=1)

  • Hash Cond: (identitem.organism_id = tx.id)
15. 52.379 52.379 ↑ 1.0 44,176 1

Seq Scan on identificationitem identitem (cost=0.00..855.76 rows=44,176 width=16) (actual time=0.014..52.379 rows=44,176 loops=1)

16. 0.011 0.030 ↑ 1.0 1 1

Hash (cost=6.30..6.30 rows=1 width=16) (actual time=0.030..0.030 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.019 0.019 ↑ 1.0 1 1

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

  • Index Cond: (refid = '103446'::bigint)
18. 0.014 0.108 ↑ 1.0 1 1

Hash (cost=2.52..2.52 rows=1 width=8) (actual time=0.108..0.108 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.094 0.094 ↑ 1.0 1 1

Seq Scan on systemtype syst (cost=0.00..2.52 rows=1 width=8) (actual time=0.082..0.094 rows=1 loops=1)

  • Filter: (upper((type)::text) ~~ '%MSID%'::text)
  • Rows Removed by Filter: 34
Planning time : 4.690 ms
Execution time : 1,256.155 ms