explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pe3P

Settings
# exclusive inclusive rows x rows loops node
1. 22,906.962 416,235.403 ↓ 2.8 715,565 1

GroupAggregate (cost=1.14..1,153,803,999.73 rows=255,977 width=89) (actual time=199,669.210..416,235.403 rows=715,565 loops=1)

  • Group Key: ncm.id
2. 37,635.802 393,328.441 ↓ 199.2 50,988,923 1

Nested Loop (cost=1.14..1,153,798,240.25 rows=255,977 width=50) (actual time=0.234..393,328.441 rows=50,988,923 loops=1)

3. 55,374.590 253,472.465 ↑ 1.2 51,110,087 1

Index Scan using normalized_counsel_mention_201910231742_attorney_cluster_id_idx on normalized_counsel_mention_20191023174259 ncm_other (cost=0.57..602,135,016.73 rows=59,663,544 width=33) (actual time=0.028..253,472.465 rows=51,110,087 loops=1)

  • Filter: ((NOT filter_out) OR (alternatives: SubPlan 3 or hashed SubPlan 4))
  • Rows Removed by Filter: 18423306
4.          

SubPlan (for Index Scan)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm_2 (cost=0.57..8.59 rows=1 width=0) (never executed)

  • Index Cond: (id = ncm_other.id)
  • Filter: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
6. 192,011.129 198,097.875 ↑ 1.0 1,426,110 1

Bitmap Heap Scan on unnormalized_counsel_mention ucm_3 (cost=35,797.39..4,302,923.16 rows=1,483,388 width=8) (actual time=6,353.529..198,097.875 rows=1,426,110 loops=1)

  • Recheck Cond: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
  • Heap Blocks: exact=675048
7. 6,086.746 6,086.746 ↑ 1.0 1,478,407 1

Bitmap Index Scan on unnormalized_counsel_mention_source_idx (cost=0.00..35,426.55 rows=1,483,388 width=0) (actual time=6,086.746..6,086.746 rows=1,478,407 loops=1)

  • Index Cond: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
8. 75,680.578 102,220.174 ↑ 1.0 1 51,110,087

Index Scan using normalized_counsel_mention_20191023174259_pkey on normalized_counsel_mention_20191023174259 ncm (cost=0.57..9.25 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=51,110,087)

  • Index Cond: (id = ncm_other.attorney_cluster_id)
  • Filter: ((id = attorney_cluster_id) AND ((NOT filter_out) OR (alternatives: SubPlan 1 or hashed SubPlan 2)))
  • Rows Removed by Filter: 0
9.          

SubPlan (for Index Scan)

10. 26,539.596 26,539.596 ↑ 1.0 1 737,211

Index Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm (cost=0.57..8.59 rows=1 width=0) (actual time=0.036..0.036 rows=1 loops=737,211)

  • Index Cond: (id = ncm.id)
  • Filter: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
  • Rows Removed by Filter: 0
11. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on unnormalized_counsel_mention ucm_1 (cost=35,797.39..4,302,923.16 rows=1,483,388 width=8) (never executed)

  • Recheck Cond: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on unnormalized_counsel_mention_source_idx (cost=0.00..35,426.55 rows=1,483,388 width=0) (never executed)

  • Index Cond: (source = ANY ('{lex_metadata,lex_sigblock}'::text[]))
Planning time : 0.648 ms
Execution time : 416,313.670 ms