explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YjyQ : example

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 1.417 ↓ 2.0 6 1

HashAggregate (cost=398.75..398.78 rows=3 width=8) (actual time=1.414..1.417 rows=6 loops=1)

2. 0.018 1.402 ↑ 2.5 21 1

Nested Loop Left Join (cost=0.42..398.49 rows=53 width=8) (actual time=0.696..1.402 rows=21 loops=1)

3. 1.354 1.354 ↓ 2.0 6 1

Seq Scan on assays (cost=0.00..251.71 rows=3 width=4) (actual time=0.683..1.354 rows=6 loops=1)

  • Filter: (work_order_id = 800)
  • Rows Removed by Filter: 8456
4. 0.030 0.030 ↑ 6.0 4 6

Index Only Scan using unique_assay_sample on assay_samples assc (cost=0.42..48.68 rows=24 width=8) (actual time=0.003..0.005 rows=4 loops=6)

  • Index Cond: (assay_id = assays.id)
  • Heap Fetches: 21