explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VLIL

Settings
# exclusive inclusive rows x rows loops node
1. 15.971 78.704 ↓ 1.0 16,008 1

Nested Loop (cost=619.19..1,277.94 rows=16,005 width=692) (actual time=7.132..78.704 rows=16,008 loops=1)

  • Output: NULL::text, date_trunc('second'::text, endorsement.created), endorsement_invoice.number, endorsement.type, endorsement.short_term_premium_method, endorsement.effective, endorsement.expiration, endorsement.home_state, endorsement.policy_number, endorsement.policy_effective, endorsement.expiration, endorsement.binder_number, endorsement.placement_reason, endorsement_insured.name, endorsement_insured.mailing_address1, endorsement_insured.mailing_address2, endorsement_insured.mailing_city, endorsement_insured.mailing_state, endorsement_insured.mailing_postal_code, endorsement.application_type, endorsement.operations_description
  • Inner Unique: true
  • Buffers: shared hit=51,056 read=328
2. 13.415 28.821 ↓ 16,956.0 16,956 1

Hash Join (cost=618.90..1,237.50 rows=1 width=135) (actual time=7.108..28.821 rows=16,956 loops=1)

  • Output: endorsement_invoice.number, endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_insured.name, endorsement_insured.mailing_address1, endorsement_insured.mailing_address2, endorsement_insured.mailing_city, endorsement_insured.mailing_state, endorsement_insured.mailing_postal_code, endorsement_insured.endorsement_id, endorsement_insured.due_to_endorsement_id
  • Hash Cond: ((endorsement_insured.endorsement_id = endorsement_invoice.endorsement_id) AND (endorsement_insured.due_to_endorsement_id = endorsement_invoice.due_to_endorsement_id))
  • Buffers: shared hit=202 read=314
3. 8.333 8.333 ↑ 1.0 17,005 1

Seq Scan on reporting.endorsement_insured (cost=0.00..491.05 rows=17,005 width=96) (actual time=0.008..8.333 rows=17,005 loops=1)

  • Output: endorsement_insured.id, endorsement_insured.endorsement_id, endorsement_insured.first_name, endorsement_insured.name, endorsement_insured.mailing_address1, endorsement_insured.mailing_address2, endorsement_insured.mailing_city, endorsement_insured.mailing_county, endorsement_insured.mailing_state, endorsement_insured.mailing_postal_code, endorsement_insured.mailing_country, endorsement_insured.due_to_endorsement_id
  • Buffers: shared hit=7 read=314
4. 4.102 7.073 ↑ 1.0 16,956 1

Hash (cost=364.56..364.56 rows=16,956 width=39) (actual time=7.073..7.073 rows=16,956 loops=1)

  • Output: endorsement_invoice.number, endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id
  • Buckets: 32,768 Batches: 1 Memory Usage: 1,432kB
  • Buffers: shared hit=195
5. 2.971 2.971 ↑ 1.0 16,956 1

Seq Scan on reporting.endorsement_invoice (cost=0.00..364.56 rows=16,956 width=39) (actual time=0.008..2.971 rows=16,956 loops=1)

  • Output: endorsement_invoice.number, endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id
  • Buffers: shared hit=195
6. 33.912 33.912 ↑ 1.0 1 16,956

Index Scan using endorsement_pkey on reporting.endorsement (cost=0.29..0.43 rows=1 width=617) (actual time=0.002..0.002 rows=1 loops=16,956)

  • Output: endorsement.id, endorsement.policy_id, endorsement.created, endorsement.posted, endorsement.number, endorsement.type, endorsement.status, endorsement.description, endorsement.effective, endorsement.expiration, endorsement.bind, endorsement.issuance, endorsement.cancellation_code, endorsement.cancellation_description, endorsement.short_term_premium_method, endorsement.policy_effective, endorsement.policy_number, endorsement.home_state, endorsement.binder_number, endorsement.placement_reason, endorsement.application_type, endorsement.admitted, endorsement.operations_description, endorsement.due_to_endorsement_id, endorsement.invalidates_endorsement_id, endorsement.invoiced
  • Index Cond: ((endorsement.id = endorsement_invoice.endorsement_id) AND (endorsement.due_to_endorsement_id = endorsement_invoice.due_to_endorsement_id))
  • Filter: (NOT endorsement.admitted)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=50,854 read=14
Planning time : 0.595 ms
Execution time : 79.987 ms