explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AFYU

Settings
# exclusive inclusive rows x rows loops node
1. 1,530.239 488,200.052 ↓ 3.2 1,195,090 1

GroupAggregate (cost=7,329,869.04..7,367,071.20 rows=368,341 width=44) (actual time=485,495.992..488,200.052 rows=1,195,090 loops=1)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
2. 5,543.335 486,669.813 ↓ 1.2 2,598,612 1

Sort (cost=7,329,869.04..7,335,302.02 rows=2,173,193 width=492) (actual time=485,495.937..486,669.813 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 481,126.478 ↓ 1.2 2,598,612 1

Gather (cost=1,000.57..6,618,310.93 rows=2,173,193 width=492) (actual time=2.848..481,126.478 rows=2,598,612 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 480,243.931 481,749.308 ↑ 1.0 866,204 3

Nested Loop (cost=0.57..6,399,991.63 rows=905,497 width=492) (actual time=2.585..481,749.308 rows=866,204 loops=3)

5. 1,504.825 1,504.825 ↑ 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.031..1,504.825 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.552 0.552 ↑ 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.552..0.552 rows=1 loops=2,598,612)

  • Index Cond: (id = cr.id)
Planning time : 12.530 ms
Execution time : 488,355.143 ms