explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YP0i

Settings
# exclusive inclusive rows x rows loops node
1. 1,447.805 1,845,147.186 ↓ 3.2 1,195,090 1

GroupAggregate (cost=7,328,707.16..7,365,903.15 rows=368,280 width=44) (actual time=1,842,328.798..1,845,147.186 rows=1,195,090 loops=1)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
2. 8,953.184 1,843,699.381 ↓ 1.2 2,598,612 1

Sort (cost=7,328,707.16..7,334,139.24 rows=2,172,833 width=492) (actual time=1,842,328.562..1,843,699.381 rows=2,598,612 loops=1)

  • Sort Key: cr.law_firm_cluster_id, cr.case_id
  • Sort Method: external merge Disk: 468856kB
3. 972.297 1,834,746.197 ↓ 1.2 2,598,612 1

Gather (cost=1,000.57..6,617,270.03 rows=2,172,833 width=492) (actual time=8.064..1,834,746.197 rows=2,598,612 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
4. 1,828,386.039 1,833,773.900 ↓ 2.9 2,598,612 1

Nested Loop (cost=0.57..6,398,986.73 rows=905,347 width=492) (actual time=7.367..1,833,773.900 rows=2,598,612 loops=1)

5. 5,387.159 5,387.159 ↓ 2.9 2,598,612 1

Parallel Seq Scan on lex_counsel_representation_20191130052230 cr (cost=0.00..62,587.61 rows=905,347 width=20) (actual time=3.966..5,387.159 rows=2,598,612 loops=1)

  • 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: 1085295
6. 0.702 0.702 ↑ 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.702..0.702 rows=1 loops=2,598,612)

  • Index Cond: (id = cr.id)
Planning time : 58.741 ms
Execution time : 1,845,294.103 ms