explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EXhb

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

Group (cost=5,838,380.32..5,928,015.96 rows=368,341 width=12) (actual time=448,673.131..449,417.877 rows=1,195,090 loops=1)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
2. 0.000 449,520.368 ↓ 2.1 1,578,247 1

Gather Merge (cost=5,838,380.32..5,924,332.55 rows=736,682 width=12) (actual time=448,673.128..449,520.368 rows=1,578,247 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,669.704 1,346,463.435 ↓ 1.4 526,082 3

Sort (cost=5,837,380.30..5,838,301.15 rows=368,341 width=12) (actual time=448,644.064..448,821.145 rows=526,082 loops=3)

  • Sort Key: cr.law_firm_cluster_id, cr.case_id
  • Sort Method: quicksort Memory: 49326kB
  • Worker 0: Sort Method: quicksort Memory: 49242kB
  • Worker 1: Sort Method: quicksort Memory: 36854kB
4. 5,523.489 1,344,793.731 ↓ 1.4 526,082 3

Partial HashAggregate (cost=5,799,642.50..5,803,325.91 rows=368,341 width=12) (actual time=448,056.935..448,264.577 rows=526,082 loops=3)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
5. 4,818.471 1,339,270.242 ↑ 1.0 866,204 3

Nested Loop (cost=0.57..5,795,115.02 rows=905,497 width=12) (actual time=4.150..446,423.414 rows=866,204 loops=3)

6. 3,962.427 3,962.427 ↑ 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.023..1,320.809 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,330,489.344 1,330,489.344 ↑ 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.512..0.512 rows=1 loops=2,598,612)

  • Index Cond: (id = cr.id)
  • Heap Fetches: 2567740
Planning time : 9.513 ms
Execution time : 449,840.888 ms