explain.depesz.com

PostgreSQL's explain analyze made readable

Result: klk7

Settings
# exclusive inclusive rows x rows loops node
1. 71.870 260.570 ↑ 1.0 840,281 1

Append (cost=0.00..59,534.74 rows=845,316 width=232) (actual time=0.015..260.570 rows=840,281 loops=1)

2. 0.045 0.045 ↑ 1.0 43 1

Seq Scan on t_e20so1_document_datastore_1 (cost=0.00..3.43 rows=43 width=223) (actual time=0.013..0.045 rows=43 loops=1)

3. 118.320 118.320 ↓ 1.0 479,001 1

Seq Scan on t_e20so1_document_datastore_11 (cost=0.00..31,319.51 rows=478,651 width=233) (actual time=0.017..118.320 rows=479,001 loops=1)

4. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on t_e20so1_document_datastore_12 (cost=0.00..1.01 rows=1 width=230) (actual time=0.017..0.017 rows=1 loops=1)

5. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_14 (cost=0.00..12.20 rows=220 width=338) (actual time=0.002..0.002 rows=0 loops=1)

6. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_38 (cost=0.00..10.90 rows=90 width=842) (actual time=0.004..0.004 rows=0 loops=1)

7. 0.151 0.151 ↑ 1.0 570 1

Seq Scan on t_e20so1_document_datastore_45 (cost=0.00..51.70 rows=570 width=218) (actual time=0.027..0.151 rows=570 loops=1)

8. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_58 (cost=0.00..13.30 rows=330 width=216) (actual time=0.004..0.004 rows=0 loops=1)

9. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_67 (cost=0.00..13.10 rows=310 width=235) (actual time=0.003..0.003 rows=0 loops=1)

10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_73 (cost=0.00..12.20 rows=220 width=339) (actual time=0.002..0.002 rows=0 loops=1)

11. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_76 (cost=0.00..12.90 rows=290 width=249) (actual time=0.002..0.002 rows=0 loops=1)

12. 0.012 0.012 ↑ 1.0 59 1

Seq Scan on t_e20so1_document_datastore_83 (cost=0.00..2.59 rows=59 width=682) (actual time=0.007..0.012 rows=59 loops=1)

13. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on t_e20so1_document_datastore_84 (cost=0.00..1.02 rows=2 width=716) (actual time=0.003..0.004 rows=2 loops=1)

14. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_86 (cost=0.00..13.40 rows=340 width=212) (actual time=0.002..0.003 rows=0 loops=1)

15. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_87 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.002..0.003 rows=0 loops=1)

16. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_89 (cost=0.00..11.00 rows=100 width=730) (actual time=0.005..0.005 rows=0 loops=1)

17. 0.004 0.004 ↑ 1.0 4 1

Seq Scan on t_e20so1_document_datastore_90 (cost=0.00..1.04 rows=4 width=234) (actual time=0.004..0.004 rows=4 loops=1)

18. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_91 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.002..0.002 rows=0 loops=1)

19. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_109 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.003..0.003 rows=0 loops=1)

20. 0.006 0.006 ↑ 1.0 10 1

Seq Scan on t_e20so1_document_datastore_110 (cost=0.00..1.10 rows=10 width=251) (actual time=0.005..0.006 rows=10 loops=1)

21. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_119 (cost=0.00..12.80 rows=280 width=254) (actual time=0.003..0.003 rows=0 loops=1)

22. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on t_e20so1_document_datastore_120 (cost=0.00..1.01 rows=1 width=227) (actual time=0.003..0.004 rows=1 loops=1)

23. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_121 (cost=0.00..13.50 rows=350 width=205) (actual time=0.002..0.002 rows=0 loops=1)

24. 0.075 0.075 ↑ 1.1 345 1

Seq Scan on t_e20so1_document_datastore_123 (cost=0.00..16.85 rows=385 width=240) (actual time=0.011..0.075 rows=345 loops=1)

25. 62.409 62.409 ↓ 1.0 327,909 1

Seq Scan on t_e20so1_document_datastore_125 (cost=0.00..20,420.81 rows=327,881 width=225) (actual time=0.009..62.409 rows=327,909 loops=1)

26. 0.025 0.025 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_126 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.025..0.025 rows=0 loops=1)

27. 0.010 0.010 ↑ 1.0 8 1

Seq Scan on t_e20so1_document_datastore_133 (cost=0.00..1.08 rows=8 width=1,188) (actual time=0.010..0.010 rows=8 loops=1)

28. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_134 (cost=0.00..11.00 rows=100 width=722) (actual time=0.014..0.014 rows=0 loops=1)

29. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_136 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.011..0.011 rows=0 loops=1)

30. 0.016 0.016 ↓ 2.0 10 1

Seq Scan on t_e20so1_document_datastore_137 (cost=0.00..2.05 rows=5 width=221) (actual time=0.014..0.016 rows=10 loops=1)

31. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_139 (cost=0.00..11.10 rows=110 width=703) (actual time=0.019..0.019 rows=0 loops=1)

32. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_140 (cost=0.00..13.20 rows=320 width=223) (actual time=0.009..0.009 rows=0 loops=1)

33. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_141 (cost=0.00..13.30 rows=330 width=217) (actual time=0.013..0.013 rows=0 loops=1)

34. 0.018 0.018 ↑ 9.4 36 1

Seq Scan on t_e20so1_document_datastore_143 (cost=0.00..13.40 rows=340 width=210) (actual time=0.013..0.018 rows=36 loops=1)

35. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_144 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.006..0.006 rows=0 loops=1)

36. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_145 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.008..0.009 rows=0 loops=1)

37. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_147 (cost=0.00..13.00 rows=300 width=242) (actual time=0.007..0.007 rows=0 loops=1)

38. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_148 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.006..0.006 rows=0 loops=1)

39. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_149 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.002..0.002 rows=0 loops=1)

40. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_150 (cost=0.00..11.00 rows=100 width=716) (actual time=0.009..0.009 rows=0 loops=1)

41. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_151 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.008..0.008 rows=0 loops=1)

42. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_153 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.002..0.002 rows=0 loops=1)

43. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_155 (cost=0.00..11.00 rows=100 width=719) (actual time=0.008..0.008 rows=0 loops=1)

44. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_156 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.005..0.005 rows=0 loops=1)

45. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_157 (cost=0.00..11.10 rows=110 width=697) (actual time=0.002..0.002 rows=0 loops=1)

46. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_169 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.007..0.007 rows=0 loops=1)

47. 7.240 7.240 ↑ 1.0 31,705 1

Seq Scan on t_e20so1_document_datastore_178 (cost=0.00..3,009.05 rows=31,705 width=239) (actual time=0.005..7.240 rows=31,705 loops=1)

48. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_180 (cost=0.00..10.60 rows=60 width=1,176) (actual time=0.012..0.012 rows=0 loops=1)

49. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_181 (cost=0.00..13.40 rows=340 width=207) (actual time=0.019..0.019 rows=0 loops=1)

50. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on t_e20so1_document_datastore_182 (cost=0.00..1.06 rows=6 width=685) (actual time=0.004..0.005 rows=6 loops=1)

51. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on t_e20so1_document_datastore_183 (cost=0.00..1.01 rows=1 width=239) (actual time=0.004..0.004 rows=1 loops=1)

52. 0.067 0.067 ↑ 1.0 514 1

Seq Scan on t_e20so1_document_datastore_184 (cost=0.00..24.14 rows=514 width=688) (actual time=0.006..0.067 rows=514 loops=1)

53. 0.010 0.010 ↑ 1.0 3 1

Seq Scan on t_e20so1_document_datastore_185 (cost=0.00..1.03 rows=3 width=679) (actual time=0.010..0.010 rows=3 loops=1)

54. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_188 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.002..0.002 rows=0 loops=1)

55. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_189 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.003..0.003 rows=0 loops=1)

56. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_190 (cost=0.00..11.00 rows=100 width=725) (actual time=0.015..0.015 rows=0 loops=1)

57. 0.004 0.004 ↑ 1.0 5 1

Seq Scan on t_e20so1_document_datastore_191 (cost=0.00..1.05 rows=5 width=703) (actual time=0.003..0.004 rows=5 loops=1)

58. 0.008 0.008 ↑ 1.0 34 1

Seq Scan on t_e20so1_document_datastore_192 (cost=0.00..2.34 rows=34 width=695) (actual time=0.004..0.008 rows=34 loops=1)

59. 0.015 0.015 ↓ 1.8 14 1

Seq Scan on t_e20so1_document_datastore_193 (cost=0.00..1.08 rows=8 width=709) (actual time=0.014..0.015 rows=14 loops=1)

60. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_194 (cost=0.00..10.30 rows=30 width=2,222) (actual time=0.003..0.003 rows=0 loops=1)

61. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_e20so1_document_datastore_default (cost=0.00..11.00 rows=100 width=720) (actual time=0.002..0.002 rows=0 loops=1)

Planning time : 28.371 ms
Execution time : 296.620 ms