explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1lTq

Settings
# exclusive inclusive rows x rows loops node
1. 0.341 2,063.270 ↑ 1.0 1 1

Aggregate (cost=15,656.40..15,656.41 rows=1 width=8) (actual time=2,063.269..2,063.270 rows=1 loops=1)

2. 0.687 2,062.929 ↓ 206.0 206 1

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

  • Hash Cond: (ir.systemtype_id = syst.id)
3. 4.385 2,062.183 ↓ 206.0 206 1

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

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

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

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

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

  • Merge Cond: (identitems.identifications_id = tr.identifications_id)
6. 49.422 49.422 ↑ 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.049..49.422 rows=44,151 loops=1)

  • Heap Fetches: 0
7. 12.242 1,697.670 ↑ 1.0 2,751 1

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

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

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

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

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

10. 5.622 12.874 ↑ 1.0 2,751 1

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

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

  • Index Cond: ((status = ANY ('{ToReview,Refused,InProgress,ToSolve}'::text[])) AND (display = true))
  • Filter: display
  • Heap Fetches: 0
12. 55.423 55.423 ↑ 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.053..55.423 rows=50,396 loops=1)

  • Heap Fetches: 0
13. 11.680 145.767 ↓ 1,234.7 7,408 1

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

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

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

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

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

16. 0.006 0.016 ↑ 1.0 1 1

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

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

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

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

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

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

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

  • Filter: (upper((type)::text) ~~ '%MSID%'::text)
  • Rows Removed by Filter: 34
Planning time : 2.417 ms
Execution time : 2,063.641 ms