explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 30Ae

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

Nested Loop (cost=8.17..10.66 rows=1 width=8,018) (actual rows= loops=)

  • Join Filter: (document.document_type_id = document_type.id)
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.17..9.43 rows=1 width=8,018) (actual rows= loops=)

  • Hash Cond: (companies.id = document.company_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on companies (cost=0.00..1.18 rows=18 width=4,598) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=8.16..8.16 rows=1 width=3,420) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using document_inquiry_id_7fc80f35 on document (cost=0.14..8.16 rows=1 width=3,420) (actual rows= loops=)

  • Index Cond: (inquiry_id = 1909)
  • Filter: is_active
6. 0.000 0.000 ↓ 0.0

Seq Scan on document_type (cost=0.00..1.21 rows=1 width=4) (actual rows= loops=)

  • Filter: ((name)::text = 'Purchase Quotation'::text)