explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ki1m

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

GroupAggregate (cost=182,059.66..188,376.06 rows=42,823 width=57) (actual rows= loops=)

  • Group Key: v_policies.underwriter_name, (date_trunc('month'::text, prodservicedataquoterequest.createdat))
2. 0.000 0.000 ↓ 0.0

Sort (cost=182,059.61..182,166.66 rows=42,823 width=65) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.03 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.03 rows=1 width=8) (actual rows= loops=)

  • Sort Key: v_policies.underwriter_name, (date_trunc('month'::text, prodservicedataquoterequest.createdat))
5. 0.000 0.000 ↓ 0.0

Gather (cost=89,423.14..178,765.21 rows=42,823 width=65) (actual rows= loops=)

  • Workers Planned: 1
  • Params Evaluated: $0, $1
6. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=88,423.14..173,482.91 rows=25,190 width=65) (actual rows= loops=)

  • Hash Cond: (prodservicedataquoterequest.id = v_policies.quote_id)
7. 0.000 0.000 ↓ 0.0

Parallel Index Scan using idx771tfz9p9gudl6k1c294d_prodservicedataquoterequest_1 on "lr$771tfz9p9gudl6k1c294d_prodservicedataquoterequest" prodservicedataquoterequest (cost=0.43..74,567.05 rows=25,190 width=49) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=70,216.09..70,216.09 rows=670,609 width=90) (actual rows= loops=)

  • Index Cond: ((createdat >= $0) AND (createdat < $1))
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "lr$77ss2c1rj6m91z7rt9l1g_v_policies" v_policies (cost=0.00..70,216.09 rows=670,609 width=90) (actual rows= loops=)