explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sJVm

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

Nested Loop (cost=8.17..10.66 rows=1 width=9,088) (actual time=0.026..0.026 rows=0 loops=1)

  • Join Filter: (document.document_type_id = document_type.id)
2. 0.012 0.026 ↓ 0.0 0 1

Hash Right Join (cost=8.17..9.43 rows=1 width=8,021) (actual time=0.026..0.026 rows=0 loops=1)

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

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

4. 0.000 0.014 ↓ 0.0 0 1

Hash (cost=8.16..8.16 rows=1 width=3,423) (actual time=0.014..0.014 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.014 0.014 ↓ 0.0 0 1

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

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

Seq Scan on document_type (cost=0.00..1.21 rows=1 width=1,067) (never executed)

  • Filter: ((name)::text = 'Purchase Quotation'::text)
Planning time : 0.843 ms
Execution time : 0.167 ms