explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DX4x

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.041 ↓ 0.0 0 1

Hash Semi Join (cost=43,238.44..58,646.58 rows=273,315 width=24) (actual time=0.041..0.041 rows=0 loops=1)

  • Hash Cond: (w.sample_id = ds.id)
2. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=43,190.44..48,656.74 rows=546,630 width=24) (never executed)

  • Group Key: w.id, (NULL::integer), w.plate_id, w.sample_id, (NULL::integer), w.x_coord, w.y_coord
3. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..33,624.42 rows=546,630 width=24) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Seq Scan on dnasample_well w (cost=0.00..8,337.83 rows=391,183 width=24) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=13,227.62..17,087.14 rows=155,447 width=24) (never executed)

  • Hash Cond: (ww.sample_id = w_1.id)
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on well_well ww (cost=0.00..3,451.47 rows=155,447 width=16) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash (cost=8,337.83..8,337.83 rows=391,183 width=12) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on dnasample_well w_1 (cost=0.00..8,337.83 rows=391,183 width=12) (never executed)

9. 0.000 0.027 ↓ 0.0 0 1

Hash (cost=47.98..47.98 rows=2 width=4) (actual time=0.027..0.027 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
10. 0.002 0.027 ↓ 0.0 0 1

Nested Loop (cost=1.27..47.98 rows=2 width=4) (actual time=0.027..0.027 rows=0 loops=1)

11. 0.025 0.025 ↓ 0.0 0 1

Index Only Scan using organism_pkey on organism o (cost=0.42..8.44 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (id = 1063538)
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..39.52 rows=2 width=8) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using cultivated_sample_organism_id_idx on cultivated_sample cs (cost=0.42..14.17 rows=3 width=8) (never executed)

  • Index Cond: (organism_id = 1063538)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using dnasample_cultivated_sample_id_idx on dnasample ds (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (cultivated_sample_id = cs.id)
Planning time : 1.164 ms
Execution time : 8.532 ms