explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6mzy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 398,119.432 ↓ 3.2 1,195,090 1

Group (cost=5,838,380.32..5,928,015.96 rows=368,341 width=12) (actual time=397,320.733..398,119.432 rows=1,195,090 loops=1)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
2. 0.000 398,194.573 ↓ 2.1 1,579,621 1

Gather Merge (cost=5,838,380.32..5,924,332.55 rows=736,682 width=12) (actual time=397,320.729..398,194.573 rows=1,579,621 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,518.438 1,192,230.408 ↓ 1.4 526,540 3

Sort (cost=5,837,380.30..5,838,301.15 rows=368,341 width=12) (actual time=397,247.642..397,410.136 rows=526,540 loops=3)

  • Sort Key: cr.law_firm_cluster_id, cr.case_id
  • Sort Method: quicksort Memory: 49396kB
  • Worker 0: Sort Method: quicksort Memory: 36854kB
  • Worker 1: Sort Method: quicksort Memory: 49236kB
4. 5,297.685 1,190,711.970 ↓ 1.4 526,540 3

Partial HashAggregate (cost=5,799,642.50..5,803,325.91 rows=368,341 width=12) (actual time=396,697.487..396,903.990 rows=526,540 loops=3)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
5. 4,237.032 1,185,414.285 ↑ 1.0 866,204 3

Nested Loop (cost=0.57..5,795,115.02 rows=905,497 width=12) (actual time=1.710..395,138.095 rows=866,204 loops=3)

6. 4,006.017 4,006.017 ↑ 1.0 866,204 3

Parallel Seq Scan on lex_counsel_representation_20191130052230 cr (cost=0.00..62,591.42 rows=905,497 width=20) (actual time=0.066..1,335.339 rows=866,204 loops=3)

  • Filter: ((NOT filter_out) OR (filter_name = ANY ('{SIGBLOCK_LAW_FIRM_INFERENCE_FILTER,ORPHANAGE_FILTER,SIGBLOCK_PARTY_VALIDATION_FILTER,PARTYLESS_FILTER}'::text[])))
  • Rows Removed by Filter: 361765
7. 1,177,171.236 1,177,171.236 ↑ 1.0 1 2,598,612

Index Only Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm (cost=0.57..6.33 rows=1 width=8) (actual time=0.453..0.453 rows=1 loops=2,598,612)

  • Index Cond: (id = cr.id)
  • Heap Fetches: 2567740
Planning time : 1.666 ms
Execution time : 398,548.139 ms