explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mudFS

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

Nested Loop (cost=8.30..31.44 rows=2 width=187) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Only Scan using account_partner_un on account a (cost=0.14..8.16 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = 1)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.15..23.26 rows=2 width=195) (actual rows= loops=)

  • Hash Cond: (fc.company_id = c.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on first_consult fc (cost=0.00..13.70 rows=370 width=187) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=8.14..8.14 rows=1 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using company_account_accountant_un on company c (cost=0.12..8.14 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (account_id = 1)