explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0ws

Settings
# exclusive inclusive rows x rows loops node
1. 207.721 588,902.197 ↓ 3.2 1,195,090 1

Group (cost=1,001.02..5,893,946.30 rows=368,311 width=12) (actual time=125.047..588,902.197 rows=1,195,090 loops=1)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
2. 0.000 588,694.476 ↓ 1.6 1,201,633 1

Gather Merge (cost=1,001.02..5,890,263.19 rows=736,622 width=12) (actual time=125.044..588,694.476 rows=1,201,633 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,457.375 1,520,076.966 ↓ 1.1 400,544 3

Group (cost=1.00..5,804,238.71 rows=368,311 width=12) (actual time=26.141..506,692.322 rows=400,544 loops=3)

  • Group Key: cr.law_firm_cluster_id, cr.case_id
4. 4,376.019 1,517,619.591 ↑ 1.0 866,204 3

Nested Loop (cost=1.00..5,799,707.83 rows=906,176 width=12) (actual time=26.139..505,873.197 rows=866,204 loops=3)

5. 3,450.000 3,450.000 ↑ 1.0 866,204 3

Parallel Index Only Scan using david_lcr_cluster_case on lex_counsel_representation_20191130052230 cr (cost=0.43..63,076.31 rows=906,176 width=20) (actual time=0.086..1,150.000 rows=866,204 loops=3)

  • Heap Fetches: 0
6. 1,509,793.572 1,509,793.572 ↑ 1.0 1 2,598,612

Index Only Scan using unnormalized_counsel_mention_pkey on unnormalized_counsel_mention ucm (cost=0.57..6.33 rows=1 width=8) (actual time=0.581..0.581 rows=1 loops=2,598,612)

  • Index Cond: (id = cr.id)
  • Heap Fetches: 2567740
Planning time : 73.075 ms
Execution time : 589,509.730 ms