explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wois

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

Group (cost=5,838,380.32..5,928,015.96 rows=368,341 width=12) (actual time=533,129.845..534,017.444 rows=1,195,090 loops=1)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
2. 0.000 534,081.576 ↓ 2.1 1,578,395 1

Gather Merge (cost=5,838,380.32..5,924,332.55 rows=736,682 width=12) (actual time=533,129.842..534,081.576 rows=1,578,395 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,889.502 1,599,945.903 ↓ 1.4 526,132 3

Sort (cost=5,837,380.30..5,838,301.15 rows=368,341 width=12) (actual time=533,101.457..533,315.301 rows=526,132 loops=3)

  • Sort Key: cr.law_firm_cluster_id, cr.case_id
  • Sort Method: quicksort Memory: 49390kB
  • Worker 0: Sort Method: quicksort Memory: 36767kB
  • Worker 1: Sort Method: quicksort Memory: 49272kB
4. 6,290.496 1,598,056.401 ↓ 1.4 526,132 3

Partial HashAggregate (cost=5,799,642.50..5,803,325.91 rows=368,341 width=12) (actual time=532,439.234..532,685.467 rows=526,132 loops=3)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
5. 6,651.420 1,591,765.905 ↑ 1.0 866,204 3

Nested Loop (cost=0.57..5,795,115.02 rows=905,497 width=12) (actual time=3.886..530,588.635 rows=866,204 loops=3)

6. 5,158.389 5,158.389 ↑ 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.024..1,719.463 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,579,956.096 1,579,956.096 ↑ 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.608..0.608 rows=1 loops=2,598,612)

  • Index Cond: (id = cr.id)
  • Heap Fetches: 2567740
Planning time : 10.938 ms
Execution time : 534,452.516 ms