explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xGT9

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 143.633 ↓ 0.0 1,002 1

Nested loop inner join (cost=10852.34 rows=46346) (cost=0..0 rows=0 width=0) (actual time=5.834..143.633 rows=1,002 loops=1)

2. 29.715 29.715 ↓ 0.0 42,539 1

Index scan on t1 using PRIMARY (cost=2355.96 rows=46346) (cost=0..0 rows=0 width=0) (actual time=0.211..29.715 rows=42,539 loops=1)

3. 42.539 127.617 ↓ 0.0 0 42,539

Filter: (t1.MEASURE_TIME > (sysdate() - interval 1 day)) (cost=0.25 rows=1) (cost=0..0 rows=0 width=0) (actual time=0.003..0.003 rows=0 loops=42,539)

4. 85.078 85.078 ↓ 0.0 1 42,539

Single-row index lookup on t2 using PRIMARY (REVIEW_EQ=t1.REVIEW_EQ, PRODUCT=t1.PRODUCT, LAYER_ID=t1.LAYER_ID, WAFER_KEY=t1.WAFER_KEY, DEFECT_ID=t1.DEFECT_ID, MEASURE_TIME=t1.MEASURE_TIME) (cost=0.25 rows=1) (cost=0..0 rows=0 width=0) (actual time=0.002..0.002 rows=1 loops=42,539)