explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4mLM

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

Group (cost=130,777.80..132,009.21 rows=8,892 width=18) (actual rows= loops=)

  • Group Key: (date_trunc('month'::text, ((CURRENT_DATE - 30))::timestamp with time zone)), t1.client_id
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=130,777.80..131,875.83 rows=8,892 width=18) (actual rows= loops=)

  • Workers Planned: 4
3. 0.000 0.000 ↓ 0.0

Group (cost=129,777.74..129,816.64 rows=2,223 width=18) (actual rows= loops=)

  • Group Key: (date_trunc('month'::text, ((CURRENT_DATE - 30))::timestamp with time zone)), t1.client_id
4. 0.000 0.000 ↓ 0.0

Sort (cost=129,777.74..129,783.30 rows=2,223 width=18) (actual rows= loops=)

  • Sort Key: t1.client_id
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..129,654.16 rows=2,223 width=18) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on tpan t2 (cost=0.00..102,734.09 rows=14,423 width=19) (actual rows= loops=)

  • Filter: (cardproduct = '7'::numeric)
7. 0.000 0.000 ↓ 0.0

Index Scan using cd_dl_res_log_client_id_idx on cd_dl_res_log t1 (cost=0.43..1.85 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((client_id)::text = (t2.client_id)::text)
  • Filter: (((dlrs_br)::text ~~ 'mono_%'::text) AND ((dlrs_br)::text <> 'mono_car'::text) AND ((dlrs_st)::text = ANY ('{DONE,DELIVERED}'::text[])) AND (dlrs_evdt < t2.activationdtm))