explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UDRv

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 268,967.033 ↓ 0.0 0 1

GroupAggregate (cost=9,602,455.74..9,602,592.61 rows=7,821 width=16) (actual time=268,967.032..268,967.033 rows=0 loops=1)

  • Group Key: simple_cargo.waybill_number
2. 0.025 268,967.030 ↓ 0.0 0 1

Sort (cost=9,602,455.74..9,602,475.29 rows=7,821 width=8) (actual time=268,967.030..268,967.030 rows=0 loops=1)

  • Sort Key: simple_cargo.waybill_number
  • Sort Method: quicksort Memory: 25kB
3. 0.000 268,967.005 ↓ 0.0 0 1

Nested Loop (cost=11,260.96..9,601,949.99 rows=7,821 width=8) (actual time=268,967.005..268,967.005 rows=0 loops=1)

4. 140.823 268,967.127 ↓ 0.0 0 1

Gather (cost=11,260.96..9,601,811.81 rows=313 width=24) (actual time=268,966.995..268,967.127 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.004 268,826.304 ↓ 0.0 0 3 / 3

Nested Loop (cost=10,260.96..9,600,780.51 rows=130 width=24) (actual time=268,826.304..268,826.304 rows=0 loops=3)

6. 0.018 268,826.300 ↓ 0.0 0 3 / 3

Nested Loop (cost=10,260.39..9,600,429.80 rows=130 width=32) (actual time=268,826.299..268,826.300 rows=0 loops=3)

7. 624.354 268,807.541 ↓ 0.0 0 3 / 3

Merge Join (cost=10,259.82..2,051,820.84 rows=1,019 width=48) (actual time=268,807.534..268,807.541 rows=0 loops=3)

  • Merge Cond: (consilidated_cp.uuid = acceptance_lnk.cargo_place_uuid)
8. 268,150.291 268,150.291 ↑ 15.7 3,378,045 3 / 3

Parallel Index Only Scan using cargo_place_pkey on cargo_place consilidated_cp (cost=0.57..1,918,872.91 rows=53,145,620 width=16) (actual time=29.741..268,150.291 rows=3,378,045 loops=3)

  • Heap Fetches: 0
9. 32.896 32.896 ↑ 2,446.0 1 3 / 3

Index Only Scan using document_cargo_place_lnk_document_uuid_cargo_place_uuid_key on document_cargo_place_lnk acceptance_lnk (cost=0.57..67.57 rows=2,446 width=32) (actual time=32.891..32.896 rows=1 loops=3)

  • Index Cond: (document_uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
10. 18.741 18.741 ↓ 0.0 0 1 / 3

Index Scan using cargo_place_history_idnext_index on cargo_place_history (cost=0.57..7,402.74 rows=512 width=32) (actual time=56.222..56.222 rows=0 loops=1)

  • Index Cond: (id_next = consilidated_cp.uuid)
  • Filter: is_last
  • Rows Removed by Filter: 228
11. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using cargo_place_pkey on cargo_place simple_cargo (cost=0.57..2.70 rows=1 width=24) (never executed)

  • Index Cond: (uuid = cargo_place_history.cargo_place_uuid)
12. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..40.43 rows=25 width=16) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..40.30 rows=25 width=16) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on document_p2018_11 adoc (cost=0.00..1.11 rows=1 width=16) (never executed)

  • Filter: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2018_12_pkey on document_p2018_12 adoc_1 (cost=0.28..1.40 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_01_pkey on document_p2019_01 adoc_2 (cost=0.29..1.41 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_02_pkey on document_p2019_02 adoc_3 (cost=0.29..1.41 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_03_pkey on document_p2019_03 adoc_4 (cost=0.41..1.53 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_04_pkey on document_p2019_04 adoc_5 (cost=0.41..1.53 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_05_pkey on document_p2019_05 adoc_6 (cost=0.42..1.54 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_06_pkey on document_p2019_06 adoc_7 (cost=0.42..1.54 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_07_pkey on document_p2019_07 adoc_8 (cost=0.42..1.54 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_08_pkey on document_p2019_08 adoc_9 (cost=0.42..1.54 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_09_pkey on document_p2019_09 adoc_10 (cost=0.42..1.54 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
25. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_10_pkey on document_p2019_10 adoc_11 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
26. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_11_pkey on document_p2019_11 adoc_12 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
27. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2019_12_pkey on document_p2019_12 adoc_13 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
28. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_01_pkey on document_p2020_01 adoc_14 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_02_pkey on document_p2020_02 adoc_15 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_03_pkey on document_p2020_03 adoc_16 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_04_pkey on document_p2020_04 adoc_17 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_05_pkey on document_p2020_05 adoc_18 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_06_pkey on document_p2020_06 adoc_19 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_07_pkey on document_p2020_07 adoc_20 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
35. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_08_pkey on document_p2020_08 adoc_21 (cost=0.43..1.55 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_09_pkey on document_p2020_09 adoc_22 (cost=0.14..2.36 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
37. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_10_pkey on document_p2020_10 adoc_23 (cost=0.14..2.36 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
38. 0.000 0.000 ↓ 0.0 0

Index Only Scan using document_p2020_11_pkey on document_p2020_11 adoc_24 (cost=0.14..2.36 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '9cdbafb9-1b51-4462-86f2-d926e4e1d4ec'::uuid)
  • Heap Fetches: 0
Planning time : 459.415 ms
Execution time : 268,967.640 ms