explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jEpJ

Settings
# exclusive inclusive rows x rows loops node
1. 55,082.724 14,551,258.706 ↓ 3.6 706,455 1

GroupAggregate (cost=1.14..1,125,077,698.33 rows=195,524 width=89) (actual time=74.162..14,551,258.706 rows=706,455 loops=1)

  • Group Key: ncm.id
2. 41,406.429 14,496,175.982 ↓ 273.0 53,382,844 1

Nested Loop (cost=1.14..1,125,072,810.23 rows=195,524 width=71) (actual time=0.719..14,496,175.982 rows=53,382,844 loops=1)

3. 1,963,032.456 14,185,702.938 ↓ 1.0 53,813,323 1

Index Scan using normalized_counsel_mention_201911300522_attorney_cluster_id_idx on normalized_counsel_mention_20191130052230 ncm_other (cost=0.57..630,804,836.10 rows=53,355,399 width=33) (actual time=0.019..14,185,702.938 rows=53,813,323 loops=1)

  • Filter: ((NOT filter_out) OR ((filter_name = ANY ('{SIGBLOCK_LAW_FIRM_INFERENCE_FILTER,ORPHAN_FILTER,SIGBLOCK_PARTY_VALIDATION_FILTER,PARTYLESS_FILTER}'::text[])) AND (SubPlan 2)))
  • Rows Removed by Filter: 18861230
4.          

SubPlan (for Index Scan)

5. 12,222,670.482 12,222,670.482 ↓ 0.0 0 12,548,943

Index Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm_1 (cost=0.57..8.59 rows=1 width=0) (actual time=0.974..0.974 rows=0 loops=12,548,943)

  • Index Cond: (id = ncm_other.id)
  • Filter: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
  • Rows Removed by Filter: 1
6. 258,119.343 269,066.615 ↑ 1.0 1 53,813,323

Index Scan using normalized_counsel_mention_20191130052230_pkey on normalized_counsel_mention_20191130052230 ncm (cost=0.57..9.26 rows=1 width=54) (actual time=0.005..0.005 rows=1 loops=53,813,323)

  • Index Cond: (id = ncm_other.attorney_cluster_id)
  • Filter: ((id = attorney_cluster_id) AND ((NOT filter_out) OR ((filter_name = ANY ('{SIGBLOCK_LAW_FIRM_INFERENCE_FILTER,ORPHAN_FILTER,SIGBLOCK_PARTY_VALIDATION_FILTER,PARTYLESS_FILTER}'::text[])) AND (SubPlan 1))))
  • Rows Removed by Filter: 0
7.          

SubPlan (for Index Scan)

8. 10,947.272 10,947.272 ↑ 1.0 1 1,563,896

Index Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm (cost=0.57..8.59 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=1,563,896)

  • Index Cond: (id = ncm.id)
  • Filter: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
  • Rows Removed by Filter: 0
Planning time : 82.980 ms
Execution time : 14,551,559.506 ms