explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M1V4 : fast non-analyze

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=28,242,219.43..28,715,722.74 rows=347,359 width=89) (actual rows= loops=)

  • Group Key: ncm_1.id, ncm_1.attorney_name
2. 0.000 0.000 ↓ 0.0

Sort (cost=28,242,219.43..28,335,878.01 rows=37,463,434 width=50) (actual rows= loops=)

  • Sort Key: ncm_1.id, ncm_1.attorney_name
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=17,908,098.24..22,249,021.53 rows=37,463,434 width=50) (actual rows= loops=)

  • Hash Cond: (ncm_other.attorney_cluster_id = ncm_1.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=15,490,704.76..19,265,683.00 rows=51,016,190 width=33) (actual rows= loops=)

  • Hash Cond: (ncm_other.id = ucm_other.id)
  • Join Filter: ((NOT ncm_other.filter_out) OR (ucm_other.source = ANY ('{lex_metadata,lex_sigblock}'::text[])))
5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,913,973.08 rows=69,471,673 width=42) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on normalized_counsel_mention ncm_other (cost=0.00..0.00 rows=1 width=57) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on normalized_counsel_mention_20191023174259 ncm_other_1 (cost=0.00..1,566,614.72 rows=69,471,672 width=42) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=14,057,331.56..14,057,331.56 rows=78,073,056 width=22) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on unnormalized_counsel_mention ucm_other (cost=0.00..14,057,331.56 rows=78,073,056 width=22) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=2,414,204.97..2,414,204.97 rows=255,081 width=41) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.57..2,414,204.97 rows=255,081 width=41) (actual rows= loops=)

  • Workers Planned: 2
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..2,387,696.87 rows=106,284 width=41) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..1,234,453.29 rows=144,733 width=34) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on normalized_counsel_mention_20191023174259 ncm_1 (cost=0.00..1,233,729.62 rows=144,732 width=34) (actual rows= loops=)

  • Filter: (id = attorney_cluster_id)
15. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on normalized_counsel_mention ncm (cost=0.00..0.00 rows=1 width=49) (actual rows= loops=)

  • Filter: (id = attorney_cluster_id)
16. 0.000 0.000 ↓ 0.0

Index Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm (cost=0.57..7.96 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (id = ncm_1.id)
  • Filter: ((NOT ncm_1.filter_out) OR (source = ANY ('{lex_metadata,lex_sigblock}'::text[])))