explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9EUR

Settings
# exclusive inclusive rows x rows loops node
1. 14,311.806 106,505.478 ↓ 16,006.0 16,006 1

Nested Loop Left Join (cost=33,227.44..46,545.74 rows=1 width=1,453) (actual time=556.011..106,505.478 rows=16,006 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_carrier.name, endorsement_carrier.naic_number, endorsement_agency.name, 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, COALESCE(((COALESCE(max(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text = 'GENAG'::text)), '0'::bigint) + COALESCE((sum(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text <> 'GENAG'::text)))::bigint, '0'::bigint))), '0'::bigint), COALESCE((COALESCE(max(endorsement_coverage_deductible.amount), '0'::bigint)), '0'::bigint), (array_agg(DISTINCT (endorsement_invoice_line_item.line_of_business)::text ORDER BY (endorsement_invoice_line_item.line_of_business)::text)), CASE WHEN ((COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)) >= 0) THEN (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)) ELSE '0'::bigint END, CASE WHEN ((COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)) < 0) THEN (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)) ELSE '0'::bigint END, (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENCY_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CLEARINGHOUSE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'EMPA'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'FIRE_MARSHALL_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'GROSS_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'HEALTHY_HOMES'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'MGA_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'OTHER'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'RISK_MANAGEMENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STAMPING_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STATE_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WILLCOMPLY_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WINDPOOL_FEE'::text)))::bigint, '0'::bigint))
  • Inner Unique: true
  • Join Filter: ((endorsement_coverage_1.endorsement_id = endorsement.id) AND (endorsement_coverage_1.due_to_endorsement_id = endorsement.due_to_endorsement_id))
  • Rows Removed by Join Filter: 128,084,948
  • Buffers: shared hit=149,065 read=2,984, temp read=3,218 written=3,238
2. 15,885.751 59,189.300 ↓ 16,006.0 16,006 1

Nested Loop Left Join (cost=26,421.93..39,227.19 rows=1 width=1,433) (actual time=434.633..59,189.300 rows=16,006 loops=1)

  • Output: endorsement.created, endorsement.type, endorsement.short_term_premium_method, endorsement.effective, endorsement.expiration, endorsement.home_state, endorsement.policy_number, endorsement.policy_effective, endorsement.binder_number, endorsement.placement_reason, endorsement.application_type, endorsement.operations_description, endorsement.id, endorsement.due_to_endorsement_id, endorsement_invoice.number, (array_agg(DISTINCT (endorsement_invoice_line_item.line_of_business)::text ORDER BY (endorsement_invoice_line_item.line_of_business)::text)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENCY_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CLEARINGHOUSE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'EMPA'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'FIRE_MARSHALL_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'GROSS_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'HEALTHY_HOMES'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'MGA_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'OTHER'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'RISK_MANAGEMENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STAMPING_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STATE_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WILLCOMPLY_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WINDPOOL_FEE'::text)))::bigint, '0'::bigint)), 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_carrier.name, endorsement_carrier.naic_number, endorsement_agency.name, ((COALESCE(max(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text = 'GENAG'::text)), '0'::bigint) + COALESCE((sum(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text <> 'GENAG'::text)))::bigint, '0'::bigint)))
  • Inner Unique: true
  • Join Filter: ((endorsement_coverage.endorsement_id = endorsement.id) AND (endorsement_coverage.due_to_endorsement_id = endorsement.due_to_endorsement_id))
  • Rows Removed by Join Filter: 130,904,770
  • Buffers: shared hit=147,957 read=2,780, temp read=2,443 written=2,463
3. 41.393 1,367.829 ↓ 16,006.0 16,006 1

Nested Loop (cost=15,672.73..27,855.02 rows=1 width=1,425) (actual time=155.702..1,367.829 rows=16,006 loops=1)

  • Output: endorsement.created, endorsement.type, endorsement.short_term_premium_method, endorsement.effective, endorsement.expiration, endorsement.home_state, endorsement.policy_number, endorsement.policy_effective, endorsement.binder_number, endorsement.placement_reason, endorsement.application_type, endorsement.operations_description, endorsement.id, endorsement.due_to_endorsement_id, endorsement_invoice.number, (array_agg(DISTINCT (endorsement_invoice_line_item.line_of_business)::text ORDER BY (endorsement_invoice_line_item.line_of_business)::text)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENCY_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CLEARINGHOUSE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'EMPA'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'FIRE_MARSHALL_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'GROSS_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'HEALTHY_HOMES'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'MGA_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'OTHER'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'RISK_MANAGEMENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STAMPING_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STATE_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WILLCOMPLY_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WINDPOOL_FEE'::text)))::bigint, '0'::bigint)), 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_carrier.name, endorsement_carrier.naic_number, endorsement_agency.name
  • Buffers: shared hit=147,948 read=627, temp read=951 written=955
4. 50.645 1,150.370 ↓ 16,006.0 16,006 1

Nested Loop (cost=15,672.44..27,854.63 rows=1 width=986) (actual time=155.693..1,150.370 rows=16,006 loops=1)

  • Output: endorsement.created, endorsement.type, endorsement.short_term_premium_method, endorsement.effective, endorsement.expiration, endorsement.home_state, endorsement.policy_number, endorsement.policy_effective, endorsement.binder_number, endorsement.placement_reason, endorsement.application_type, endorsement.operations_description, endorsement.id, endorsement.due_to_endorsement_id, endorsement_invoice.number, (array_agg(DISTINCT (endorsement_invoice_line_item.line_of_business)::text ORDER BY (endorsement_invoice_line_item.line_of_business)::text)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENCY_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CLEARINGHOUSE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'EMPA'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'FIRE_MARSHALL_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'GROSS_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'HEALTHY_HOMES'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'MGA_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'OTHER'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'RISK_MANAGEMENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STAMPING_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STATE_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WILLCOMPLY_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WINDPOOL_FEE'::text)))::bigint, '0'::bigint)), 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, endorsement_agency.name, endorsement_agency.endorsement_id, endorsement_agency.due_to_endorsement_id
  • Buffers: shared hit=100,237 read=320, temp read=951 written=955
5. 68.770 987.683 ↓ 16,006.0 16,006 1

Nested Loop (cost=15,672.15..27,854.21 rows=1 width=890) (actual time=155.682..987.683 rows=16,006 loops=1)

  • Output: endorsement.created, endorsement.type, endorsement.short_term_premium_method, endorsement.effective, endorsement.expiration, endorsement.home_state, endorsement.policy_number, endorsement.policy_effective, endorsement.binder_number, endorsement.placement_reason, endorsement.application_type, endorsement.operations_description, endorsement.id, endorsement.due_to_endorsement_id, endorsement_invoice.number, (array_agg(DISTINCT (endorsement_invoice_line_item.line_of_business)::text ORDER BY (endorsement_invoice_line_item.line_of_business)::text)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENCY_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CLEARINGHOUSE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'EMPA'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'FIRE_MARSHALL_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'GROSS_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'HEALTHY_HOMES'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'MGA_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'OTHER'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'RISK_MANAGEMENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STAMPING_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STATE_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WILLCOMPLY_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WINDPOOL_FEE'::text)))::bigint, '0'::bigint)), endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_agency.name, endorsement_agency.endorsement_id, endorsement_agency.due_to_endorsement_id
  • Inner Unique: true
  • Buffers: shared hit=52,320 read=219, temp read=951 written=955
6. 59.273 715.465 ↓ 16,954.0 16,954 1

Hash Join (cost=15,671.86..27,853.79 rows=1 width=273) (actual time=155.660..715.465 rows=16,954 loops=1)

  • Output: endorsement_invoice.number, (array_agg(DISTINCT (endorsement_invoice_line_item.line_of_business)::text ORDER BY (endorsement_invoice_line_item.line_of_business)::text)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENCY_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CLEARINGHOUSE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'EMPA'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'FIRE_MARSHALL_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'GROSS_COMMISSION'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'HEALTHY_HOMES'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'INSPECTION_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'MGA_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'OTHER'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'RISK_MANAGEMENT_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STAMPING_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STATE_TAX'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WILLCOMPLY_FEE'::text)))::bigint, '0'::bigint)), (COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WINDPOOL_FEE'::text)))::bigint, '0'::bigint)), endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_agency.name, endorsement_agency.endorsement_id, endorsement_agency.due_to_endorsement_id
  • Hash Cond: ((endorsement_invoice.endorsement_id = endorsement_agency.endorsement_id) AND (endorsement_invoice.due_to_endorsement_id = endorsement_agency.due_to_endorsement_id))
  • Buffers: shared hit=1,458 read=219, temp read=951 written=955
7. 443.826 644.879 ↑ 1.0 16,954 1

GroupAggregate (cost=15,025.74..26,910.92 rows=16,956 width=215) (actual time=144.324..644.879 rows=16,954 loops=1)

  • Output: endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_invoice.number, array_agg(DISTINCT (endorsement_invoice_line_item.line_of_business)::text ORDER BY (endorsement_invoice_line_item.line_of_business)::text), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'PREMIUM'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENCY_COMMISSION'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'AGENT_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CARRIER_INSPECTION_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'CLEARINGHOUSE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'EMPA'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'FIRE_MARSHALL_TAX'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'GROSS_COMMISSION'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'HEALTHY_HOMES'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'INSPECTION_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'MGA_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'OTHER'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'RISK_MANAGEMENT_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STAMPING_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'STATE_TAX'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WILLCOMPLY_FEE'::text)))::bigint, '0'::bigint), COALESCE((sum(endorsement_invoice_line_item.amount) FILTER (WHERE ((endorsement_invoice_line_item.type)::text = 'WINDPOOL_FEE'::text)))::bigint, '0'::bigint)
  • Group Key: endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_invoice.number
  • Buffers: shared hit=1,456, temp read=951 written=955
8. 137.530 201.053 ↑ 1.0 98,997 1

Sort (cost=15,025.74..15,273.23 rows=98,997 width=62) (actual time=144.286..201.053 rows=98,997 loops=1)

  • Output: endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_invoice.number, endorsement_invoice_line_item.line_of_business, endorsement_invoice_line_item.amount, endorsement_invoice_line_item.type
  • Sort Key: endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_invoice.number
  • Sort Method: external merge Disk: 7,608kB
  • Buffers: shared hit=1,456, temp read=951 written=955
9. 42.024 63.523 ↑ 1.0 98,997 1

Hash Join (cost=576.51..3,087.41 rows=98,997 width=62) (actual time=8.404..63.523 rows=98,997 loops=1)

  • Output: endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_invoice.number, endorsement_invoice_line_item.line_of_business, endorsement_invoice_line_item.amount, endorsement_invoice_line_item.type
  • Inner Unique: true
  • Hash Cond: (endorsement_invoice_line_item.invoice_id = endorsement_invoice.id)
  • Buffers: shared hit=1,456
10. 13.257 13.257 ↑ 1.0 98,997 1

Seq Scan on reporting.endorsement_invoice_line_item (cost=0.00..2,250.97 rows=98,997 width=39) (actual time=0.010..13.257 rows=98,997 loops=1)

  • Output: endorsement_invoice_line_item.id, endorsement_invoice_line_item.invoice_id, endorsement_invoice_line_item.broad_type, endorsement_invoice_line_item.type, endorsement_invoice_line_item.line_of_business, endorsement_invoice_line_item.description, endorsement_invoice_line_item.amount, endorsement_invoice_line_item.rate
  • Buffers: shared hit=1,261
11. 5.098 8.242 ↑ 1.0 16,956 1

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

  • Output: endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_invoice.number, endorsement_invoice.id
  • Buckets: 32,768 Batches: 1 Memory Usage: 1,697kB
  • Buffers: shared hit=195
12. 3.144 3.144 ↑ 1.0 16,956 1

Seq Scan on reporting.endorsement_invoice (cost=0.00..364.56 rows=16,956 width=55) (actual time=0.012..3.144 rows=16,956 loops=1)

  • Output: endorsement_invoice.endorsement_id, endorsement_invoice.due_to_endorsement_id, endorsement_invoice.number, endorsement_invoice.id
  • Buffers: shared hit=195
13. 5.490 11.313 ↑ 1.0 17,005 1

Hash (cost=391.05..391.05 rows=17,005 width=58) (actual time=11.313..11.313 rows=17,005 loops=1)

  • Output: endorsement_agency.name, endorsement_agency.endorsement_id, endorsement_agency.due_to_endorsement_id
  • Buckets: 32,768 Batches: 1 Memory Usage: 1,753kB
  • Buffers: shared hit=2 read=219
14. 5.823 5.823 ↑ 1.0 17,005 1

Seq Scan on reporting.endorsement_agency (cost=0.00..391.05 rows=17,005 width=58) (actual time=0.166..5.823 rows=17,005 loops=1)

  • Output: endorsement_agency.name, endorsement_agency.endorsement_id, endorsement_agency.due_to_endorsement_id
  • Buffers: shared hit=2 read=219
15. 203.448 203.448 ↑ 1.0 1 16,954

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

  • 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,862
16. 112.042 112.042 ↑ 1.0 1 16,006

Index Scan using endorsement_insured_endorsement_id_due_to_endorsement_id_idx on reporting.endorsement_insured (cost=0.29..0.41 rows=1 width=96) (actual time=0.006..0.007 rows=1 loops=16,006)

  • 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
  • Index 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=47,917 read=101
17. 176.066 176.066 ↑ 1.0 1 16,006

Index Scan using endorsement_carrier_endorsement_id_due_to_endorsement_id_idx on reporting.endorsement_carrier (cost=0.29..0.38 rows=1 width=567) (actual time=0.007..0.011 rows=1 loops=16,006)

  • Output: endorsement_carrier.id, endorsement_carrier.endorsement_id, endorsement_carrier.name, endorsement_carrier.naic_number, endorsement_carrier.due_to_endorsement_id
  • Index Cond: ((endorsement_carrier.endorsement_id = endorsement_invoice.endorsement_id) AND (endorsement_carrier.due_to_endorsement_id = endorsement_invoice.due_to_endorsement_id))
  • Buffers: shared hit=47,711 read=307
18. 41,680.650 41,935.720 ↑ 1.8 8,179 16,006

Finalize HashAggregate (cost=10,749.20..11,005.72 rows=14,658 width=40) (actual time=0.019..2.620 rows=8,179 loops=16,006)

  • Output: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id, (COALESCE(max(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text = 'GENAG'::text)), '0'::bigint) + COALESCE((sum(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text <> 'GENAG'::text)))::bigint, '0'::bigint))
  • Group Key: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id
  • Buffers: shared hit=9 read=2,153, temp read=1,492 written=1,508
19. 29.995 255.070 ↓ 2.0 28,642 1

Gather (cost=8,916.95..10,565.98 rows=14,658 width=72) (actual time=224.559..255.070 rows=28,642 loops=1)

  • Output: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id, (PARTIAL max(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text = 'GENAG'::text))), (PARTIAL sum(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text <> 'GENAG'::text)))
  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=9 read=2,153, temp read=1,492 written=1,508
20. 39.518 225.075 ↑ 1.0 14,321 2 / 2

Partial HashAggregate (cost=7,916.95..8,100.18 rows=14,658 width=72) (actual time=215.899..225.075 rows=14,321 loops=2)

  • Output: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id, PARTIAL max(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text = 'GENAG'::text)), PARTIAL sum(endorsement_coverage_limit.amount) FILTER (WHERE ((endorsement_coverage.coverage_code)::text <> 'GENAG'::text))
  • Group Key: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id
  • Buffers: shared hit=9 read=2,153, temp read=1,492 written=1,508
  • Worker 0: actual time=210.475..220.010 rows=14,721 loops=1
  • Buffers: shared hit=4 read=1,079, temp read=686 written=764
21. 71.793 185.557 ↑ 1.2 45,918 2 / 2

Parallel Hash Join (cost=3,424.01..7,106.64 rows=54,021 width=45) (actual time=147.305..185.557 rows=45,918 loops=2)

  • Output: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id, endorsement_coverage_limit.amount, endorsement_coverage.coverage_code
  • Inner Unique: true
  • Hash Cond: ((endorsement_coverage_limit.coverage_id = endorsement_coverage.id) AND (endorsement_coverage_limit.endorsement_id = endorsement_coverage.endorsement_id) AND (endorsement_coverage_limit.due_to_endorsement_id = endorsement_coverage.due_to_endorsement_id))
  • Buffers: shared hit=9 read=2,153, temp read=1,492 written=1,508
  • Worker 0: actual time=135.163..176.305 rows=53,022 loops=1
  • Buffers: shared hit=4 read=1,079, temp read=686 written=764
22. 33.753 33.753 ↑ 1.2 45,918 2 / 2

Parallel Seq Scan on reporting.endorsement_coverage_limit (cost=0.00..1,593.21 rows=54,021 width=56) (actual time=0.332..33.753 rows=45,918 loops=2)

  • Output: endorsement_coverage_limit.amount, endorsement_coverage_limit.coverage_id, endorsement_coverage_limit.endorsement_id, endorsement_coverage_limit.due_to_endorsement_id
  • Buffers: shared hit=2 read=1,051
  • Worker 0: actual time=0.339..33.492 rows=48,232 loops=1
  • Buffers: shared read=552
23. 36.576 80.011 ↑ 1.2 52,855 2 / 2

Parallel Hash (cost=1,727.82..1,727.82 rows=62,182 width=53) (actual time=80.011..80.011 rows=52,855 loops=2)

  • Output: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id, endorsement_coverage.coverage_code, endorsement_coverage.id
  • Buckets: 65,536 Batches: 4 Memory Usage: 2,816kB
  • Buffers: shared hit=4 read=1,102, temp written=724
  • Worker 0: actual time=75.372..75.372 rows=50,596 loops=1
  • Buffers: shared hit=1 read=527, temp written=348
24. 43.435 43.435 ↑ 1.2 52,855 2 / 2

Parallel Seq Scan on reporting.endorsement_coverage (cost=0.00..1,727.82 rows=62,182 width=53) (actual time=0.244..43.435 rows=52,855 loops=2)

  • Output: endorsement_coverage.endorsement_id, endorsement_coverage.due_to_endorsement_id, endorsement_coverage.coverage_code, endorsement_coverage.id
  • Buffers: shared hit=4 read=1,102
  • Worker 0: actual time=0.065..39.325 rows=50,596 loops=1
  • Buffers: shared hit=1 read=527
25. 32,892.687 33,004.372 ↑ 1.8 8,003 16,006

HashAggregate (cost=6,805.52..6,952.10 rows=14,658 width=40) (actual time=0.008..2.062 rows=8,003 loops=16,006)

  • Output: endorsement_coverage_1.endorsement_id, endorsement_coverage_1.due_to_endorsement_id, COALESCE(max(endorsement_coverage_deductible.amount), '0'::bigint)
  • Group Key: endorsement_coverage_1.endorsement_id, endorsement_coverage_1.due_to_endorsement_id
  • Buffers: shared hit=1,108 read=204, temp read=775 written=775
26. 29.852 111.685 ↑ 1.0 16,177 1

Hash Join (cost=4,943.02..6,684.19 rows=16,177 width=40) (actual time=67.448..111.685 rows=16,177 loops=1)

  • Output: endorsement_coverage_1.endorsement_id, endorsement_coverage_1.due_to_endorsement_id, endorsement_coverage_deductible.amount
  • Inner Unique: true
  • Hash Cond: ((endorsement_coverage_deductible.coverage_id = endorsement_coverage_1.id) AND (endorsement_coverage_deductible.endorsement_id = endorsement_coverage_1.endorsement_id) AND (endorsement_coverage_deductible.due_to_endorsement_id = endorsement_coverage_1.due_to_endorsement_id))
  • Buffers: shared hit=1,108 read=204, temp read=775 written=775
27. 15.060 15.060 ↑ 1.0 16,177 1

Seq Scan on reporting.endorsement_coverage_deductible (cost=0.00..367.77 rows=16,177 width=56) (actual time=0.515..15.060 rows=16,177 loops=1)

  • Output: endorsement_coverage_deductible.amount, endorsement_coverage_deductible.coverage_id, endorsement_coverage_deductible.endorsement_id, endorsement_coverage_deductible.due_to_endorsement_id
  • Buffers: shared hit=2 read=204
28. 47.249 66.773 ↑ 1.0 105,710 1

Hash (cost=2,163.10..2,163.10 rows=105,710 width=48) (actual time=66.772..66.773 rows=105,710 loops=1)

  • Output: endorsement_coverage_1.endorsement_id, endorsement_coverage_1.due_to_endorsement_id, endorsement_coverage_1.id
  • Buckets: 65,536 Batches: 4 Memory Usage: 2,568kB
  • Buffers: shared hit=1,106, temp written=658
29. 19.524 19.524 ↑ 1.0 105,710 1

Seq Scan on reporting.endorsement_coverage endorsement_coverage_1 (cost=0.00..2,163.10 rows=105,710 width=48) (actual time=0.017..19.524 rows=105,710 loops=1)

  • Output: endorsement_coverage_1.endorsement_id, endorsement_coverage_1.due_to_endorsement_id, endorsement_coverage_1.id
  • Buffers: shared hit=1,106
Planning time : 31.735 ms
Execution time : 106,536.122 ms