explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZWE

Settings
# exclusive inclusive rows x rows loops node
1. 38.433 90,035.979 ↑ 3.9 81,278 1

Gather (cost=29,988.48..280,329.37 rows=317,837 width=136) (actual time=1,422.991..90,035.979 rows=81,278 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
2. 115.182 89,997.546 ↑ 1.6 81,278 1

Parallel Hash Left Join (cost=28,988.48..247,545.67 rows=132,432 width=136) (actual time=1,422.341..89,997.546 rows=81,278 loops=1)

  • Hash Cond: (attorney_representation_cache.law_firm_cluster_id = law_firm_cache_1.id)
3. 170.725 89,535.341 ↑ 1.6 81,278 1

Parallel Hash Left Join (cost=21,235.78..238,744.55 rows=132,432 width=113) (actual time=1,073.462..89,535.341 rows=81,278 loops=1)

  • Hash Cond: (attorney_representation_cache.attorney_cluster_id = attorney_cache_1.id)
4. 84.970 88,309.943 ↑ 1.6 81,278 1

Nested Loop Left Join (cost=0.85..216,461.20 rows=132,432 width=94) (actual time=12.145..88,309.943 rows=81,278 loops=1)

5. 87.708 28,255.273 ↓ 2.6 23,940 1

Nested Loop (cost=0.85..114,905.49 rows=9,269 width=78) (actual time=2.846..28,255.273 rows=23,940 loops=1)

6. 48.805 21,416.485 ↓ 2.4 23,940 1

Nested Loop (cost=0.29..107,863.54 rows=9,932 width=60) (actual time=2.712..21,416.485 rows=23,940 loops=1)

7. 11.261 1,710.366 ↓ 2.6 25,797 1

Parallel Append (cost=0.29..27,965.93 rows=9,933 width=8) (actual time=1.906..1,710.366 rows=25,797 loops=1)

8. 1,699.080 1,699.080 ↓ 1.8 25,797 1

Parallel Index Scan using ix_pacer_metadata_party_mention_case_id on pacer_metadata_party_mention pacer_all_party_mention_2 (cost=0.44..27,890.18 rows=14,017 width=8) (actual time=1.879..1,699.080 rows=25,797 loops=1)

  • Index Cond: (case_id = 2000126356)
9. 0.024 0.024 ↓ 0.0 0 1

Parallel Index Scan using ix_pacer_curation_party_mention_case_id on pacer_curation_party_mention pacer_all_party_mention_1 (cost=0.29..26.08 rows=4 width=8) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: (case_id = 2000126356)
10. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on pacer_all_party_mention (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (case_id = 2000126356)
11. 128.985 19,657.314 ↑ 2.0 1 25,797

Append (cost=0.00..8.02 rows=2 width=52) (actual time=0.761..0.762 rows=1 loops=25,797)

12. 0.000 0.000 ↓ 0.0 0 25,797

Seq Scan on normalized_party_mention (cost=0.00..0.00 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=25,797)

  • Filter: ((NOT filter_out) AND (pacer_all_party_mention_2.id = id))
13. 19,528.329 19,528.329 ↑ 1.0 1 25,797

Index Scan using normalized_party_mention_20200515135149_pkey on normalized_party_mention_20200515135149 normalized_party_mention_1 (cost=0.56..8.01 rows=1 width=52) (actual time=0.756..0.757 rows=1 loops=25,797)

  • Index Cond: (id = pacer_all_party_mention_2.id)
  • Filter: (NOT filter_out)
  • Rows Removed by Filter: 0
14. 6,751.080 6,751.080 ↑ 1.0 1 23,940

Index Scan using unnormalized_party_mention_pkey on unnormalized_party_mention (cost=0.56..0.71 rows=1 width=34) (actual time=0.282..0.282 rows=1 loops=23,940)

  • Index Cond: (id = normalized_party_mention.id)
  • Filter: (NOT filter_out)
15. 119.700 59,969.700 ↓ 1.5 3 23,940

Append (cost=0.00..10.94 rows=2 width=20) (actual time=0.804..2.505 rows=3 loops=23,940)

16. 0.000 0.000 ↓ 0.0 0 23,940

Seq Scan on attorney_representation_cache (cost=0.00..0.00 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=23,940)

  • Filter: ((case_id = 2000126356) AND (normalized_party_mention.cluster_id = litigating_entity_id))
17. 59,850.000 59,850.000 ↓ 3.0 3 23,940

Index Scan using attorney_representation_cache_20200515_litigating_entity_id_idx on attorney_representation_cache_20200515041529 attorney_representation_cache_1 (cost=0.56..10.93 rows=1 width=20) (actual time=0.800..2.500 rows=3 loops=23,940)

  • Index Cond: (normalized_party_mention.cluster_id = litigating_entity_id)
  • Filter: (case_id = 2000126356)
  • Rows Removed by Filter: 41
18. 284.651 1,054.673 ↓ 2.4 640,835 1

Parallel Hash (cost=17,897.23..17,897.23 rows=267,016 width=27) (actual time=1,054.672..1,054.673 rows=640,835 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 47552kB
19. 55.462 770.022 ↓ 2.4 640,835 1

Parallel Append (cost=0.00..17,897.23 rows=267,016 width=27) (actual time=0.013..770.022 rows=640,835 loops=1)

20. 714.559 714.559 ↓ 2.4 640,835 1

Parallel Seq Scan on attorney_cache_20200515041529 attorney_cache_1 (cost=0.00..16,562.15 rows=267,015 width=27) (actual time=0.010..714.559 rows=640,835 loops=1)

21. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on attorney_cache (cost=0.00..0.00 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)

22. 99.846 347.023 ↓ 2.4 248,525 1

Parallel Hash (cost=6,458.29..6,458.29 rows=103,553 width=31) (actual time=347.023..347.023 rows=248,525 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 18400kB
23. 21.292 247.177 ↓ 2.4 248,525 1

Parallel Append (cost=0.00..6,458.29 rows=103,553 width=31) (actual time=0.012..247.177 rows=248,525 loops=1)

24. 225.884 225.884 ↓ 2.4 248,525 1

Parallel Seq Scan on law_firm_cache_20200515041529 law_firm_cache_1 (cost=0.00..5,940.52 rows=103,552 width=31) (actual time=0.010..225.884 rows=248,525 loops=1)

25. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on law_firm_cache (cost=0.00..0.00 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)

Planning time : 2.081 ms
Execution time : 90,057.711 ms