explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jlv1

Settings
# exclusive inclusive rows x rows loops node
1. 350.581 36,845.062 ↑ 139.0 1 1

Gather (cost=1,000.00..1,565,634.15 rows=139 width=2,210) (actual time=53.939..36,845.062 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.033 36,494.481 ↓ 0.0 0 3 / 3

Append (cost=0.00..1,564,620.25 rows=68 width=2,210) (actual time=24,272.650..36,494.481 rows=0 loops=3)

3. 0.003 0.003 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_43 (cost=0.00..11.46 rows=1 width=695) (actual time=0.002..0.003 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
4. 0.005 0.005 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_42 (cost=0.00..2.00 rows=1 width=695) (actual time=0.004..0.005 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
5. 3.576 3.576 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_41 (cost=0.00..12.00 rows=1 width=695) (actual time=3.575..3.576 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
6. 2.053 2.053 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_40 (cost=0.00..30.34 rows=1 width=2,300) (actual time=0.107..2.053 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 33
7. 2.301 2.301 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_39 (cost=0.00..17.61 rows=1 width=2,405) (actual time=2.301..2.301 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 15
8. 5.804 5.804 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_38 (cost=0.00..31.14 rows=1 width=2,431) (actual time=5.803..5.804 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 29
9. 3.797 3.797 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_36 (cost=0.00..43.87 rows=1 width=2,074) (actual time=3.796..3.797 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 43
10. 5.700 5.700 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_35 (cost=0.00..49.05 rows=1 width=2,084) (actual time=5.700..5.700 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 49
11. 3.230 3.230 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_1 (cost=0.00..46.81 rows=1 width=2,290) (actual time=3.230..3.230 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 46
12. 0.460 0.460 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_24 (cost=0.00..16.60 rows=1 width=2,352) (actual time=0.459..0.460 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 15
13. 6.677 6.677 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_25 (cost=0.00..497.49 rows=1 width=2,195) (actual time=6.676..6.677 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 566
14. 21.051 21.051 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_26 (cost=0.00..429.40 rows=1 width=2,185) (actual time=21.050..21.051 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 486
15. 41.438 41.438 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_27 (cost=0.00..2,120.10 rows=1 width=2,155) (actual time=41.437..41.438 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 2,387
16. 141.993 141.993 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_28 (cost=0.00..4,509.63 rows=1 width=2,111) (actual time=141.992..141.993 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 5,036
17. 141.817 141.817 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_29 (cost=0.00..3,993.12 rows=1 width=2,111) (actual time=141.816..141.817 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 4,626
18. 172.832 172.832 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_30 (cost=0.00..4,056.97 rows=1 width=2,134) (actual time=172.831..172.832 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 4,657
19. 95.768 95.768 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_31 (cost=0.00..4,122.78 rows=1 width=2,152) (actual time=95.767..95.768 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 4,765
20. 212.275 212.275 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_32 (cost=0.00..4,028.20 rows=1 width=1,942) (actual time=212.275..212.275 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 5,028
21. 843.076 843.076 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_33 (cost=0.00..36,710.64 rows=1 width=2,152) (actual time=843.075..843.076 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 42,684
22. 864.013 864.013 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_34 (cost=0.00..66,074.52 rows=2 width=2,049) (actual time=864.012..864.013 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 77,159
23. 713.179 713.179 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_37 (cost=0.00..53,297.48 rows=2 width=2,001) (actual time=713.178..713.179 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 64,425
24. 647.831 647.831 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_132 (cost=0.00..64,680.65 rows=2 width=1,981) (actual time=647.831..647.831 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 74,866
25. 1,409.002 1,409.002 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_133 (cost=0.00..115,248.13 rows=3 width=1,993) (actual time=1,409.001..1,409.002 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 94,191
26. 3,869.556 3,869.556 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_134 (cost=0.00..174,277.57 rows=6 width=1,957) (actual time=3,869.555..3,869.556 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 189,717
27. 3,845.698 3,845.698 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_135 (cost=0.00..155,537.89 rows=6 width=1,933) (actual time=3,845.697..3,845.698 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 189,965
28. 3,507.513 3,507.513 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_136 (cost=0.00..95,837.65 rows=4 width=1,983) (actual time=3,507.512..3,507.513 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 121,188
29. 3,134.307 3,134.307 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_137 (cost=0.00..99,863.31 rows=4 width=1,870) (actual time=3,134.306..3,134.307 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 126,781
30. 5,296.818 5,296.818 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_138 (cost=0.00..135,233.99 rows=5 width=2,029) (actual time=5,296.817..5,296.818 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 161,037
31. 5,014.583 5,014.583 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_24689 (cost=0.00..347,576.87 rows=8 width=2,106) (actual time=5,014.583..5,014.583 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 236,653
32. 4,839.262 4,839.262 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_24690 (cost=0.00..148,775.92 rows=5 width=1,922) (actual time=4,839.261..4,839.262 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 163,121
33. 1,648.830 1,648.830 ↓ 0.0 0 3 / 3

Parallel Seq Scan on med_docs_24691 (cost=0.00..47,487.09 rows=2 width=2,039) (actual time=1,648.830..1,648.830 rows=0 loops=3)

  • Filter: (((doc_metadata ->> 'documentNumber'::text) = '20340683'::text) AND (((doc_metadata -> 'patient'::text) ->> 'snils'::text) = '13470887577'::text))
  • Rows Removed by Filter: 58,663
Planning time : 5.525 ms
Execution time : 36,846.064 ms