explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OVkI : Optimization for: 222; plan #pqj8

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.41..15.11 rows=50 width=542) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.41..132.10 rows=448 width=542) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Unique (cost=0.41..122.02 rows=448 width=534) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.41..120.90 rows=448 width=534) (actual rows= loops=)

  • Join Filter: (diamond_account_data.lotnumber = dc.lotnumber)
5. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.41..112.52 rows=448 width=532) (actual rows= loops=)

  • Merge Cond: (dc.lotnumber = da.lotnumber)
6. 0.000 0.000 ↓ 0.0

Index Scan using pk_diamondsquery on diamond_query dc (cost=0.27..97.83 rows=448 width=532) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using diamond_account_data_pkey on diamond_account_data da (cost=0.14..12.92 rows=52 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.65 rows=1 width=10) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on diamond_account_data (cost=0.00..1.65 rows=1 width=10) (actual rows= loops=)

  • Filter: (accountid = 638)