explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wRfQ

Settings
# exclusive inclusive rows x rows loops node
1. 1,426.124 426,708.261 ↓ 3.2 1,195,090 1

GroupAggregate (cost=7,329,869.04..7,367,071.20 rows=368,341 width=44) (actual time=423,409.764..426,708.261 rows=1,195,090 loops=1)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
2. 6,463.572 425,282.137 ↓ 1.2 2,598,612 1

Sort (cost=7,329,869.04..7,335,302.02 rows=2,173,193 width=492) (actual time=423,409.721..425,282.137 rows=2,598,612 loops=1)

  • Sort Key: cr.law_firm_cluster_id, cr.case_id
  • Sort Method: external merge Disk: 468856kB
3. 0.000 418,818.565 ↓ 1.2 2,598,612 1

Gather (cost=1,000.57..6,618,310.93 rows=2,173,193 width=492) (actual time=2.294..418,818.565 rows=2,598,612 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 417,789.247 419,226.397 ↑ 1.0 866,204 3

Nested Loop (cost=0.57..6,399,991.63 rows=905,497 width=492) (actual time=2.290..419,226.397 rows=866,204 loops=3)

5. 1,436.670 1,436.670 ↑ 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.619..1,436.670 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
6. 0.480 0.480 ↑ 1.0 1 2,598,612

Index Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm (cost=0.57..7.00 rows=1 width=488) (actual time=0.480..0.480 rows=1 loops=2,598,612)

  • Index Cond: (id = cr.id)
Planning time : 0.718 ms
Execution time : 426,842.213 ms